How I need correct formula, that no t rounding?

TANDEX · Jul 15, 2005

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.

N Harkawat · Jul 15, 2005

=trunc(h45*0.18,2)

TANDEX · Jul 15, 2005

N Harkawat said:
=trunc(h45*0.18,2)

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

How I need correct formula, that no t rounding?

TANDEX

N Harkawat

TANDEX