Get instant live expert help on how to round in excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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