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") |
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") |
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") |
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") |
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") |
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") |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com