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

Multi IF function for multiple rows

0

Hey there,

I need an IF function that can say if ANYTHING is in either column A or column B, then "Blank". One of the cells on the same row of column A and B will be empty,  But I need a way for it to ignore the blank cell. Does this make sense to anyone?

excel
MS Office Version: Noexcelguru
posted by: Noexcelguru on Thu Dec 13, 2018 at 2:22 pm
Answer
Discuss

Discussion

yeah, looking back at that, my situation wasn't explained well at all. Maybe I have been going about this the wrong way. I believe I figured out a way around that issue, but have since encountered a new issue. I was using the IF function, but I'm running into the exceeding 64 levels of nesting. Any idea to circumvent this?
Noexcelguru Dec 14, '18 at 11:29 am
Sorry, it doesn’t work that way, either. On this forum a question needs an answer. Since you solved your own problem please post your solution as an answer to your own question. Mark your own answer as “Selected” and earn reputation points. If you find that your original question wasn’t well phrased you can still edit it out of courtesy to me and other forum readers who take an interest in your problem and it’s solution.
Of course, for your new question to fit this pattern eventually it needs to be in its own thread. And I can already tell you that it will have to be explained much better. Actually, it will have to be disclosed. “Exceeding the 64 levels of nesting” isn’t the problem. It’s the wrong solution. The wrong solution to which problem?
Variatus (rep: 4889) Dec 14, '18 at 2:03 pm
Add to Discussion

Answers

0

No, it doesn't make sense. At least, it isn't clear what you want but perhaps this will help. Consider

=COUNTA(A2:B2)

This function will return 0 if both cells are blank, 1 if one of them is blank and 2 if both have something in them. Therefore the formula below would tell you when there is a value in either of the two cells you are interested in.

=IF(COUNTA(A2:B2)=1,"Got one,"Have none or two")

You might tweak the formula to do what you need it to do. Note that the "Value" could be a number or a text string.

posted by: Variatus (rep: 4889) on Thu Dec 13, 2018 at 7:28 pm
Discuss

Discussion

yeah, looking back at that, my situation wasn't explained well at all. Maybe I have been going about this the wrong way. I believe I figured out a way around that issue, but have since encountered a new issue. I was using the IF function, but I'm running into the exceeding 64 levels of nesting. Any idea to circumvent this?
Noexcelguru Dec 14, '18 at 11:38 am
Add to Discussion


Answer the Question

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