Formula Help

[njones3]

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,

 

[mole999]

do you have spaces around sales manager etc, not sure you need OR either

 

[Special-K99]

Remove the equals sign
OR requires more than one condition (usually), if there's only one then you dont need an OR
Here's an example of an AND using greater/less than

=AND(A1 >=17, A1 <= 51)

Here's an example of OR condition
=OR(A1="Rainy",A1="Sunny")

No extra equals and values not within quotes
A single cell reference doesnt brackets
BJ2 not (BJ2)

Try this (though am not familiar with Structured references, the @ sign)

=IF(AND(BG2="Sales Manager",[@[Vol NB + SA]]<=3000),3000,IF(AND(BG2="Sales Negotiator",[@[Vol NB + SA]]>=3000),2900,BJ2))

 

[njones3]

Thank you very much, that has worked perfectly.

Think I was trying to over complicate it!