View Single Post
  #3   Report Post  
TANDEX
 
Posts: n/a
Default


"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
=trunc(h45*0.18,2)

"TANDEX" wrote in message
...
Excel XP, my formula is =H45*0.18
It show value 237.57 (237.5694), but I need get 237.56 -without rounding,
2 first digits only.
How I need correct formula?

Thank you.


and what is difference with =ROUNDDOWN(H45*0.18;2) ??