| 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") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine logical formulas "if", "and", "or"
Hey man, try this one:
=If(OR(AND(AR32AV1;AS32AW1);AND(AR32<AV2;AS32<AW 2));"Problem";"Acceptable") If that works plz tell me, k? cya "pscu" escreveu: 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") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine logical formulas "if", "and", "or"
That didn't work. I got an error message that the formula contained an error.
I copied & pasted your formula in cell AT32. "mantros" wrote: Hey man, try this one: =If(OR(AND(AR32AV1;AS32AW1);AND(AR32<AV2;AS32<AW 2));"Problem";"Acceptable") If that works plz tell me, k? cya "pscu" escreveu: 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") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine logical formulas "if", "and", "or"
k, try this:
=IF(AND(AR32AV1;AS32AW1);"Problem";IF(AND(AR32<A V2;AS32<AW2);"Problem";"Acceptable")) If still doesn't work (it did here), verify if ur $ format is the same in every $ cell. The same for the % cells. Oh yeah, if ur not using an english office, careful when translating the functions, k? i'll be still here for a time, so plz test and tell if u have any trouble. cya "pscu" escreveu: That didn't work. I got an error message that the formula contained an error. I copied & pasted your formula in cell AT32. "mantros" wrote: Hey man, try this one: =If(OR(AND(AR32AV1;AS32AW1);AND(AR32<AV2;AS32<AW 2));"Problem";"Acceptable") If that works plz tell me, k? cya "pscu" escreveu: 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") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine logical formulas "if", "and", "or"
Your first formula worked fine for me - but had the change the ";" to "," for
my system (Windows based - U.S.) "mantros" wrote: k, try this: =IF(AND(AR32AV1;AS32AW1);"Problem";IF(AND(AR32<A V2;AS32<AW2);"Problem";"Acceptable")) If still doesn't work (it did here), verify if ur $ format is the same in every $ cell. The same for the % cells. Oh yeah, if ur not using an english office, careful when translating the functions, k? i'll be still here for a time, so plz test and tell if u have any trouble. cya "pscu" escreveu: That didn't work. I got an error message that the formula contained an error. I copied & pasted your formula in cell AT32. "mantros" wrote: Hey man, try this one: =If(OR(AND(AR32AV1;AS32AW1);AND(AR32<AV2;AS32<AW 2));"Problem";"Acceptable") If that works plz tell me, k? cya "pscu" escreveu: 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") |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine logical formulas "if", "and", "or"
THANK YOU BOTH..... The formula worked and I used the ",".
"JMB" wrote: Your first formula worked fine for me - but had the change the ";" to "," for my system (Windows based - U.S.) "mantros" wrote: k, try this: =IF(AND(AR32AV1;AS32AW1);"Problem";IF(AND(AR32<A V2;AS32<AW2);"Problem";"Acceptable")) If still doesn't work (it did here), verify if ur $ format is the same in every $ cell. The same for the % cells. Oh yeah, if ur not using an english office, careful when translating the functions, k? i'll be still here for a time, so plz test and tell if u have any trouble. cya "pscu" escreveu: That didn't work. I got an error message that the formula contained an error. I copied & pasted your formula in cell AT32. "mantros" wrote: Hey man, try this one: =If(OR(AND(AR32AV1;AS32AW1);AND(AR32<AV2;AS32<AW 2));"Problem";"Acceptable") If that works plz tell me, k? cya "pscu" escreveu: 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") |
| Reply |
| 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 | |||
Linear Mode
