# 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