Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you round a number then use it in another formula
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you round a number then use it in another formula
Works for me.
What is your formula and how are you rounding? Regards, Paul -- "Darice Bloom" <Darice wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you round a number then use it in another formula
assuming the number is in cell C15
and the calculation you want is in D15. (cell location really doesn't make a difference) =round(c15,1)*15-2 This formula will round cell c15 to 1 decimal place then multiply it by 15 and then subtract two..... -- Wag more, bark less "Darice Bloom" 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you round a number then use it in another formula
I assume that you are not Rounding the number but rather formatting the cell
to show only integers. Use the formula: =ROUND(Your Formula, 0) This will change the actual result of your formula into an integer. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Darice Bloom" <Darice wrote in message ... 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
can you round a number then use it in another formula
=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? |
#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? |
Reply |
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) |