Forum Discussion
Solved
Formula to show result as a whole number
How do I fix this formula to show a whole number result. =((489/1050)*100)+43.7 Answer 90.271428571 I want the answer to show 90 Thank you, Richard
If you want to round to the nearest whole number:
=ROUND(489/1050*100+43.7, 0)
If you want to round down to the next lower whole number:
=INT(489/1050*100+43.7)
or
=ROUNDDOWN(489/1050*100+43.7, 0)
If you want to round to the nearest whole number:
=ROUND(489/1050*100+43.7, 0)
If you want to round down to the next lower whole number:
=INT(489/1050*100+43.7)
or
=ROUNDDOWN(489/1050*100+43.7, 0)
Thank you! I'm just learning how to use spread sheets. If I get stuck on another problem I will definitely contact you again. I can't thank you enough.
Richard S.