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

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