Updating a list to a yes/no

[userpoets]

I'm currently trying to update a formula from a four-tiered option to a two-tiered.

The current formula looks like this:

=IF($B5="","",IF(W5=1,"Great",IF(W5=2,"Good",IF(W5=3,"Weak",IF(W5=4,"Bad","")))))

$B5 is a date field, if there's nothing there then the cell should be blank.

I'm trying to update this from a number giving a certain response to either a blank or an X. IE if cell W5 is blank, it's "Good" and if cell W5 is "x" then it's "Bad."

This looks like it should be right, but I'm getting a name error. Any idea what I'm doing wrong?

=IF($B5="","",IF(W5=x,"Bad",IF(W5="","Good")))

 

[Fluff]

You need quotes around the x

 

[userpoets]

I am blind. Thank you very much.

 

[Fluff]

If W5 can only be x or blank you could use
=IF($B5="","",IF(W5="x","Bad","Good"))