Solved Multiple IF Statement Check

December 31, 2012 at 08:31:35
Specs: Windows 7
IF I5="Y" Return "" (Dont email out)
IF I5="N" Return "Y" (Email out but depends on AX5, if AX5="Y" (Dont Email out) Return ""

AX5 is blank at the moment

hope this makes sense

Many thanks

See More: Multiple IF Statement Check

Report •

December 31, 2012 at 09:41:51
✔ Best Answer
It appears to me that you want the IF function to return "" if either I5 or AX5 = "Y".

Assuming that I5 can only contain Y or N, this should work:


To ensure that I5 can only contain Y or N, I would use a Data Validation Dropdown.

If you don't, you'll need to deal with other values and decide what you want the IF to return if I5 contains something other than Y or N.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question