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

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