Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Return Value Yes or No

0

how to get return value yes or no in excel if statement when either of two cells is blank?

Answer
Discuss

Answers

0
Selected Answer

R

If your cells are A1 and A2 say, you use the OR function within the test argument of the IF. Here I've also used the ISBLANK function to test those cells:

=IF(OR(ISBLANK(A1),ISBLANK(A2)),"Yes","No")

You just need to change the cell references to suit. 

Hope this works for you. 

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login