help with formula

M

Mur

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

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

EXCEL FORMULA 2
VBA Coding Help for Beginner 0
If, Or, and 5
Excel Formula and Variance Analysis 0
Variance between two cells only if... 5
Variance Analysis and Excel 1
Condition formula 2
Formula Help 2

Top