Get instant live expert help on round formula 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
I need a formula that applies the following rounding rules: If 0<X<0.125 Round to X=0 If 0.125<X<0.375 Round to X=0.25 If 0.375<X<0.625 Round to X=0.5 If 0.625<X<0.875 Round to X=0.75 If X> 0.875 Round to X=1
Solved by F. E. in 18 mins
i want to put which formula in excel for total sum value 1552 then it is convert automatic round figure 1552 if result is 1558 then result got 1560
Solved by B. B. in 22 mins