If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with formula
variance analysis
cell A1 is 10 input cell B1 is 5 input cell c1 is 5 formula A1 - B1 I only want to look at variances that are greater than or less than 25% of cell A1 I can create the formula and it works but if the variance is negative because A1 is less than B1 then I can't get it to show a variance..only 0 Any help would be appreciated... |
#2
|
|||
|
|||
help with formula
Not sure what is showing 0?
what is the specific formula you are using? "Mur" wrote: variance analysis cell A1 is 10 input cell B1 is 5 input cell c1 is 5 formula A1 - B1 I only want to look at variances that are greater than or less than 25% of cell A1 I can create the formula and it works but if the variance is negative because A1 is less than B1 then I can't get it to show a variance..only 0 Any help would be appreciated... |
Thread Tools | |
Display Modes | |
|
|