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")