IF statement based on a dropdown of options

[jmneal]

Hello, I am trying to figure out an If statement for the below formula. The dropdown option has a YES, NO, NEVER. If someone selects NEVER, I need it to return N/A. Any help would be appreciated. The "current occupancy" cell already has an if statement so that's why I am confused. Thank you

 

[Leo Skywalker]

Your image doesn't give much info, but something like this will work:

=IF(G28="NEVER",NA(),FALSE)

 

[Fluff]

How about something like

=if(drop down cell ="Never","N/A",your formula)

 

[jmneal]

Both of these suggestions worked great. I appreciate the help!

 

[Fluff]

Glad we could help & thanks for the feedback.