I'm not sure of the correct approach to this formula. My data is as follows in 3 columns:-
Name Date Status
What I'm trying to do in Col C is have a formula that returns Y if the name matches a set list and N for anything else in col A - I've no problem with this bit...
=IF((OR(A1="Tom", A1="Dave", A1="Fred"),"Y","N")
What I want to add in is another two IF statements that also check if Col A & Col B are blank. If either are blank then return a blank in Col C. To return a Y or N in Col C then both A & B need data (i.e. not blank).
I've tried nested IF statements but don't get the required results and using IFS gives me an error - I'm sure its simply down to syntax and how I'm structuring it - can anyone help please?
Name Date Status
What I'm trying to do in Col C is have a formula that returns Y if the name matches a set list and N for anything else in col A - I've no problem with this bit...
=IF((OR(A1="Tom", A1="Dave", A1="Fred"),"Y","N")
What I want to add in is another two IF statements that also check if Col A & Col B are blank. If either are blank then return a blank in Col C. To return a Y or N in Col C then both A & B need data (i.e. not blank).
I've tried nested IF statements but don't get the required results and using IFS gives me an error - I'm sure its simply down to syntax and how I'm structuring it - can anyone help please?