# Thread: Formula Help Thanks: 0 Likes: 0

1. ## Formula Help

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

2. ## Re: Formula Help

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

3. ## Re: Formula Help

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

4. ## Re: Formula Help

Thank you very much, that has worked perfectly.

Think I was trying to over complicate it!