Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

IF Statement

Posted on 2011-03-11
2
Medium Priority
?
209 Views
Last Modified: 2012-05-11
Hi,

I have the below IF

=IF(B2="entered","Yes","No")

I want it to not consider a blank cell "No"

If b2 is blank, formula returns blank

Thanks
Seamus
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 24

Accepted Solution

by:
jimyX earned 2000 total points
ID: 35107751
Use this:
=IF(B2="entered","Yes",IF(B2="","","No"))
0
 

Author Closing Comment

by:Seamus2626
ID: 35107756
Thank you!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question