Articles

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 •


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

=IF(OR(I5="Y",AX5="Y"),"","Y")

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