Get instant live expert help on I need help with excel round formulas

“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
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
How to do excel round to nearest 1000 with a formula in excel
Solved by S. Q. in 28 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