Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dealing with #N/A results | Excel Discussion (Misc queries) | |||
Dealing with errors | Excel Discussion (Misc queries) | |||
dealing with a projection | Charts and Charting in Excel | |||
Dealing with worksheet groups | Excel Worksheet Functions | |||
Dealing with hidden apostrophes... | Excel Discussion (Misc queries) |