Get instant live expert help on round to hundredths

“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

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
I need help with round in excel. I want to round up but my spreadsheet automatically round to the nearest number.
Solved by T. W. in 26 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
I want excel roundup to next whole number with multiple cells containing whole numbers to be rounded to either 5 or 0
Solved by M. H. in 27 mins
Please may I have assistance with creating a formula that will round up any decimal value however will not round any integers. The cells are formatted to not show any decimals. Example: 2.000001 rounds up to 3 2.000000 remains as 2
Solved by G. H. in 28 mins