Excel Formula and Variance Analysis

M

Mur

Cell A1 is 10 an input
Cell B1 is 5 an input
Cell C1 is 5 a formula of A1 - B1

I want to only see variances that are greater than 25% of cell A1 and I can
get that to work but if cell A1 is less than 5 in the above example I can't.
I want to see 25% of cell A1 regardless of whether the variances is positive
or negative

Any help would be appreciated........
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variance Analysis and Excel 1
help with formula 1
EXCEL FORMULA 2
% Variance 5
Excel Need Countifs Formula Help 0
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Excel "IF" functions 1
Multiple Criteria, One Answer 1

Top