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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>