What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??

[TANDEX]

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

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.
What formula I should use: =ROUNDDOWN(H45*0.18;2) or =TRUNK(H45*0.18,2) ??

Thank you.

 

[CLR]

With your formula in A1 returning 237.5694, this formula in B1 will return
237.56

=(INT(A1)&MID(A1,FIND(".",A1),3))*1

or in A1
=ROUNDDOWN(H45*0.18,2)

English version of Excel2k


Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

This works for me

=ROUNDDOWN(A2*0.18,2)

or

=FLOOR(A2*0.18,0.01)