Dealing with +/- Values, Need Help

  • Thread starter Thread starter Dust Devil
  • Start date Start date
D

Dust Devil

Hi, I'm trying to create a formula that will either tell the reviewer that
"YES" a variance report needs to be written, or "NO" it doesn't. I've tried
IF with AND/OR, thought about Vlookup and even dabbled with select case. My
situation is this, a variance report needs to be written if the variance is
equal to or greater than plus or minus $100,000, AND equal to or greater than
plus or minus 10%. I would be fine it the plus or minus wasn't thrown in
there, not sure how to make this work. Can anyone help me?

Thank you in advance!
 
Using the Absoluut function

=IF(AND(ABS(C7)>=100000,ABS(C7)>=0.1*A7),"Yes","no")

C7 is the cell with the variance
A7 is the original amount
 

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
Fill Color If Statement 3
Excel Formula and Variance Analysis 0
Formula for Cochran's Critical Values 9
NEED HELP WITH EXCEL FORMULA 3
help with IF formula 2
Complex formula/equation 2
Excel Need Countifs Formula Help 0

Back
Top