Dealing with +/- Values, Need Help

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!
 
B

Bill Kuunders

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
 
Top