round down?
=round(111*.84,0)
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"dbrumit" wrote:
I want to take cell a1 wich has a value of 111 in it, and multiply that by
.84. I would like the cell to then show 93 and not 93.24
If I format the cell to number and 0 decimal it will show 93 but in the
formula bar it will show 93.24
Can this be done?
Thanks
|