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