# Get instant live expert help on round decimals calculator

“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

Please may I have assistance with creating a formula that will round up any decimal value however will not round any integers. The cells are formatted to not show any decimals. Example: 2.000001 rounds up to 3 2.000000 remains as 2
Solved by G. H. in 28 mins
I am trying to add a row of numbers that include decimals. When I use the sum function it rounds the total. I know how to round but I don't know how to not round. Please advise.
Solved by E. H. in 20 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
x axis and y axis question related.N decimals allowed
Solved by C. L. in 20 mins
I have created a formula with true and false however would like it to be \$0 if the cells are blank. =IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 12 mins