Dealing with +/- Values, Need Help
 

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

Dealing with +/- Values, Need Help
 

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
--
Greetings from New Zealand


"Dust Devil" wrote in message
...
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!
--
DD