I am trying to get the correct formula for the following:
IF A7 is "no" AND B7 is between 100 and 150, AND C7 is "xx", THEN IF A8 is "yes" AND B8 is between 100 and 150, AND D8 is "xx", THEN E8 ="xx", AND IF A8 is "yes" AND B8 is between 100 and 150, AND D8 is "yy", THEN E8 = "yy"
Column A will always be either "no" or "yes" Column B will only have a number in it but that number may be lower than 100 and can even be a negative number or higher than 150. Column C will always be either "xx" or "yy" Column D will always be either "xx" or "yy" Finally if Column E does not = either "xx" or "yy" then it remains blank.
Bookmarks