| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding a number with a formula already in cell
I want to round a number after I apply a percentage to it--for example:
=F11*1.02, then round the number to the nearest 100. Is this possible? Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding a number with a formula already in cell
=ROUND(F11*1.02,-2)
-- Regards, Peo Sjoblom "CIW" wrote in message ... I want to round a number after I apply a percentage to it--for example: =F11*1.02, then round the number to the nearest 100. Is this possible? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding a number created by a formula to a retail price | Excel Worksheet Functions | |||
| Significant number rounding based on key cell | Excel Worksheet Functions | |||
| Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) | |||
| Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) | |||
| cut off number in excel cell vs. rounding | Excel Discussion (Misc queries) | |||
Linear Mode
