Updating a list to a yes/no

userpoets

New Member
Joined
Mar 21, 2019
Messages
4
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")))
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,956
Office Version
365
Platform
Windows
You need quotes around the x
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,956
Office Version
365
Platform
Windows
If W5 can only be x or blank you could use
=IF($B5="","",IF(W5="x","Bad","Good"))
 

Watch MrExcel Video

Forum statistics

Threads
1,099,580
Messages
5,469,507
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top