Get instant live expert help on I need help with excel round a number

“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 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
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 want help with round average excel. how do you round your number to the nearest 2 decimal point but after finding an average
Solved by T. Q. in 11 mins
How to do excel round to nearest 1000 with a formula in excel
Solved by S. Q. in 28 mins
I have a number in a excel formula round up that I need to round up to the next 100. For example I have a number of 2499 sq. ft that I need to calculate at a rate of $3 for every 100 feet over the first 1000 sq. ft. - that number is 1499 but I need to round up to 1500. =B60-1000 sorry if I don't make sense...
Solved by Z. C. in 22 mins