“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How to I round up to the next 1000 with a formula in excel

Solved by S. Q. in 28 mins

in excel round(89.5) = ???? please give me answer to this question

Solved by S. Q. in 25 mins

I need a hand with a nested if formula =IF($C$6="Round 1",'Round 1'!M7,IF($C$6="Round 2",IF($C$6="Round 3",IF($C$6="Round 4","")))) it works for round 1 but when i select round 2>4 it wont. i need to duplicate but not sure how to. Your help is appreciated.

Solved by Z. Y. in 14 mins

Hi, I have a little problem doing time sheets. Here is my example: If an employee clocks in before 7:15 I need the time to round to 7:00 am and if they clock in after 7:15 I need the time to round to 7:30. How can I do this ? So for example if someone clocks in at 6:47 I need the time to round to 7:00 am or if the clock at 7:10 I need the time to round to 7:00 am as well. Thank you.

Solved by A. F. in 24 mins

$27.49 i need to round this up im not sure how

Solved by M. J. in 16 mins