| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
"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) ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with formula | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Offset & Match Formula Shows Duplicates | Excel Worksheet Functions | |||
| Price rounding - exception formula required | Excel Worksheet Functions | |||
Linear Mode
