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

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.

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


"TANDEX" wrote in message
...
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.

This works for me

=ROUNDDOWN(A2*0.18,2)

or

=FLOOR(A2*0.18,0.01)

--
HTH

Bob Phillips

"TANDEX" wrote in message
...
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.