Help with an IF formula

[Marvo]

I have a formula

=IF(A4="✖",0,IF(AND(BB4>3,AQ4<$BJ$2),BL4+$BK$2,0))

that I thought that if the first criteria was met, A4="X" then a zero would be returned however it is still returning the remainder of the formula.

What have I got wrong please?

 

[Fluff]

That is not an X in the formula, it's a symbol ✖
So what is in A4?

 

[Marvo]

Gotcha. Schoolboy error. In A4 is a zero which displays as an X symbol. I've changed the formula to

=IF(A4=0,0,IF(AND(BB4>3,AQ4<$BJ$2),BL4+$BK$2,0))

Works fine.

Please excuse my stupidity and thanks very much.

 

[Fluff]

Glad it you sorted it & thanks for letting us know.