Here are some problems that our users have asked and received explanations on
i need a wildcard for numbers on the left side of the decimal when dealing with rounding up and down with specific criteria but focusing on the right side of the decimal only.
Solved by A. B. in 11 mins
Hi With excel my result is 1.932% and with a calculator it is 1.924. Can you explain the difference. I have tried rounding up and down but cannot get the same answers
Solved by Z. L. in 14 mins
Stop rounding numbers, permanently and globally.
Solved by M. J. in 27 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
need help totaling values in one column and rounding down in another