| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to roundup
How would I roundup in the following formula? I keep getting a circular reference. =E5*(1+10%) E5 is constant |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to roundup
Roundup to what?
This rounds up to the nearest penny =CEILING(E5*(1+10%),0.01) Unless you have the formula in E5 you shouldn't get circular reference if E5 is a constant -- Regards, Peo Sjoblom "Trishs" wrote in message ... How would I roundup in the following formula? I keep getting a circular reference. =E5*(1+10%) E5 is constant |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to roundup
=ROUNDUP(E5*(1+10%),number_of_places_to_which_you_ want_to_round)
You won't get a circular reference unless you try to put the formula in cell E5. -- David Biddulph "Trishs" wrote in message ... How would I roundup in the following formula? I keep getting a circular reference. =E5*(1+10%) E5 is constant |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to roundup
G'day Trish
Assumed $A$1=100 B1=IF($A$1=0,0,$A$1*1.1) Result = 110 HTH Mark. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| roundup value | Excel Discussion (Misc queries) | |||
| ROundup | Excel Worksheet Functions | |||
| RoundUp | Excel Discussion (Misc queries) | |||
| how to use roundup | Excel Discussion (Misc queries) | |||
| ROUNDUP | Excel Discussion (Misc queries) | |||
Linear Mode
