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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Fluff

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
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,102,350
Messages
5,486,344
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top