# 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?

### 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: 2938) Dec 14, '18 at 2:03 pm

## 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.

### 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