Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=round(111*.84,0)
-- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "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 | |
|
|
![]() |
||||
Thread | Forum | |||
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 | |||
How can I round UP to to the next ,50? E.g. 2,3 should become 2,5. | Excel Worksheet Functions | |||
How can i round off .10 as .50 and .51 as 1.00 | Excel Worksheet Functions |