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.
|