ExcelBanter - help with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/252590-help-formula.html)

Mur

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...

Sean Timmons

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...

All times are GMT +1. The time now is 05:38 AM.