Get instant live expert help on round sum 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

I have a spreadsheet for my local bowling club league championship. I have IF formulas in 4 cells for each round of our competition and I have a cell to calculate the sum of the 4 cells as each round is completed. I am getting ##### until all cells are full. Can I see the sum as each individual round is completed.
Solved by A. H. in 12 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
What do I add to formula =SUM(P2*70%) to round up to the next whole number. This formula gives me a percentage
Solved by O. Q. in 12 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