Referencing text from drop down list in an IF stmnt

[murraythek]

Trying to create an IF stmnt to trigger a text response but I'm struggling to put it together.

B20 is pulled from a drop down list (White Honda, Blue Honda, Black Honda etc) so I need to reference that text exactly. Note there is "1' space in front of each vehicle as you can see below.

Formula: =IF((AND(B20= "White Honda", B30>=460, B32>=460)), "Goal Met","Goal Not Met")

It keeps wanting to correct "White Honda" to "WHITEHONDA". Is there something Im missing in trying to reference that cell text as its inputted? The cell is formatted for general but changing it to text doesn't help.

If there's a better formula for this then please let me know. Basically if they sell equal to or more than 460 White Honda's I want the alert to notify them on excel.

 

[Dermot]

your formula works fine for me (apart from the fact that it has no space in front of "White Honda")

It's difficult to help with this, without seeing the actual sheet