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)
2 Replies
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.
