| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you round a number then use it in another formula
Another option is "Precision as displayed", but I wouldn't recommend it.
-- David Biddulph "Gord Dibben" <gorddibbATshawDOTca wrote in message ... =ROUND(A1,0)*B1 entered in C1 will round A1 but not B1 =ROUND(A1*B1,0) will round your result in C1 Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 12:26:03 -0700, Darice Bloom <Darice wrote: I want to use a rounded number in another formula but it uses the decimal number instead. How can I tell it to use the rounded number in the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to round a number to the nearest .09? | Excel Worksheet Functions | |||
| How do I round a formula generated number | Excel Worksheet Functions | |||
| formula to round up any number less than 35 upto 35. | Excel Discussion (Misc queries) | |||
| Need to round a formula up or down to a specific number | Excel Worksheet Functions | |||
| i would like to know a formula on how to round a number to 500 | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
