| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
round down?
I want to take cell a1 wich has a value of 111 in it, and multiply that by
..84. I would like the cell to then show 93 and not 93.24 If I format the cell to number and 0 decimal it will show 93 but in the formula bar it will show 93.24 Can this be done? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round down?
Thank you this will work great!
"Toppers" wrote: =ROUNDDOWN(a1*0.84,0) if you always want to round down or INT(A1*0.84) HTH "dbrumit" wrote: I want to take cell a1 wich has a value of 111 in it, and multiply that by .84. I would like the cell to then show 93 and not 93.24 If I format the cell to number and 0 decimal it will show 93 but in the formula bar it will show 93.24 Can this be done? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round down? | Excel Discussion (Misc queries) | |||
| How do I get a sum to round? | Excel Discussion (Misc queries) | |||
| Round up | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| how do I round up? | Excel Worksheet Functions | |||
Linear Mode
