Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL FORMULA
Need help with an excel formula.
Cell A1 is 10 an input Cell B1 is 5 anther input Cell C1 is 5 but a formula A1 - B1 I want to only analize variances that are greater than 25% of cell A1. I can create this formula but only if C is a postiive number. If cell A1 is less than B1 then I'd also like to see the variance if its outside of 25% but can't get it to work if its a negative number. Any help would be appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL FORMULA
The following will always return Ã* positive number. You can then check if it
is 25% of A1 =if(A1-B1 < 0,(A1-B1)*2+A1-B1,A1-B1) -- Yanick "Mur" wrote: Need help with an excel formula. Cell A1 is 10 an input Cell B1 is 5 anther input Cell C1 is 5 but a formula A1 - B1 I want to only analize variances that are greater than 25% of cell A1. I can create this formula but only if C is a postiive number. If cell A1 is less than B1 then I'd also like to see the variance if its outside of 25% but can't get it to work if its a negative number. Any help would be appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL FORMULA
Your formula will always tell you the difference between A1 and B1 no matter
what signs they have A B C 9 3 6 3 9 -6 This formula will tell you by what % A differs from B =(A1-B1)/B1 and format the cell percentage And this will display the variance only when it is greater than 25% IF(ABS((A1-B1)/B125%, (A1-B1)/B1,"") best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mur" wrote in message ... Need help with an excel formula. Cell A1 is 10 an input Cell B1 is 5 anther input Cell C1 is 5 but a formula A1 - B1 I want to only analize variances that are greater than 25% of cell A1. I can create this formula but only if C is a postiive number. If cell A1 is less than B1 then I'd also like to see the variance if its outside of 25% but can't get it to work if its a negative number. Any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |