Help with Nested If Statement

jstarr

New Member
Joined
Dec 1, 2014
Messages
20
I'm trying to come up with an IF statement with 3 criteria. Looking for the boards help.

The table is pulling data from another worksheet on the spreadsheet.

1. IF Column J is not blank=Yes
2. If Column J is blank=No
3. If Column J is 0=Not yet

I came up with this formula, but the columns that should be returning Not yet, are returning yes.

=IF([Column J]<>"","Yes",IF([Column J]="","No",IF([Column J]=0,"Not Yet")))

Thanks!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Fishboy

Well-known Member
Joined
Feb 13, 2015
Messages
4,261
Hi Jstarr, the reason it is returning yes instead of not yet is because the presence of a 0 in column J means the column is not blank as per <>""
 

Fishboy

Well-known Member
Joined
Feb 13, 2015
Messages
4,261
Try this:

=IF(AND(J:J<>"",J:J<>0),"Yes",IF(AND(J:J=0,J:J<>""),"Not Yet","No"))

J:J can be replaced with your named range
 

jstarr

New Member
Joined
Dec 1, 2014
Messages
20
Thanks so much. Is there a way for me to run a pivot table from this dataset that only counts the "Yes" values? I'm trying to count what percent of clients we retain.
 

Fishboy

Well-known Member
Joined
Feb 13, 2015
Messages
4,261
You're welcome. Feel free to hit the Like button on my previous post to show it was the right answer.

With regards to your second query, do you have some example data we can look at? That would help immensely to visualise your data set and allow us to try and help you further. If you google MrExcel HTML Maker you will be able to copy / paste a snippet of your workbook directly from Excel straight onto the forums.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,856
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top