Hi,
I have the below formula for a calculated column in a table but it doesn't seem to be working correctly, is there an obvious error?
=IF(AND(BG2="Sales Manager",OR([@[Vol NB + SA]]="<=3000")),"3000",IF(AND(BG2="Sales Negotiator",OR([@[Vol NB + SA]]=">=3000")),"2900",(BJ2)))
Thanks in advance,
I have the below formula for a calculated column in a table but it doesn't seem to be working correctly, is there an obvious error?
=IF(AND(BG2="Sales Manager",OR([@[Vol NB + SA]]="<=3000")),"3000",IF(AND(BG2="Sales Negotiator",OR([@[Vol NB + SA]]=">=3000")),"2900",(BJ2)))
Thanks in advance,