| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine logical formulas "if", "and", "or"
I'm trying to flag $ and % of variances within a range. If the $ variance
(AR32) is greater than $450,000 (AV1) and % variance (AS32) greater than 5% (AW1), OR, if the $ variance (AR32)is less than -$450,000(AV2) and %variance (AS32) -5% (AW2), I want to output "Problem" (AT32). If the variance falls within the $ and % range I want to output "Acceptable" (AT32) I tried the following, but it doesn't work: =IF(OR($AR32$AV$1,$AS32$AW$1,$AR32<$AV$2,$AS32<$ AW$2),"Problem","Acceptable") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you combine 2 or more formulas with different totals? | Excel Discussion (Misc queries) | |||
| Help combine 2 formulas into 1 | Excel Worksheet Functions | |||
| Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
| How do I combine the 4 IF formulas into 1 formula | Excel Worksheet Functions | |||
| How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
Threaded Mode
