View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pscu pscu is offline
external usenet poster
 
Posts: 3
Default 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")