Thread: round down?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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