ExcelBanter - How I need correct formula, that no t rounding?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How I need correct formula, that no t rounding? (https://www.excelbanter.com/excel-worksheet-functions/35570-how-i-need-correct-formula-no-t-rounding.html)

TANDEX

How I need correct formula, that no t rounding?

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

=trunc(h45*0.18,2)

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

TANDEX

"N Harkawat" <nharkawat@hotmail_dot_com wrote in message
...
=trunc(h45*0.18,2)

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

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

All times are GMT +1. The time now is 04:03 AM.