IF AND NestedFormula

[thbutterflycollector_]

Hi,

I am half-way through trying to write an IF AND formula to check various criteria and I am struggling to complete it. I was wondering if anyone can help?

In AB4 to AB11 I have an IF formula:

=IF(Z4="","",IF(Z4="Defined","Not Applicable",IF(Z4="Fee","Not Applicable"))).

The formula works to this point (at AB8) but I would like to also look up Columns Z and AA and Column K to determine the parties agree on whether an item should be paid.

If Z8 and AA8 = Disallowed and Column K = Yes AB = Yes
If Z9 does not = Disallowed and AA9 does = Disallowed AB = No (same applies to Row 10)

Can anyone kindly help?!

 

[arthurbr]

This
=IF(Z4="","",IF(Z4="Defined","Not Applicable",IF(Z4="Fee","Not Applicable"))).
can be shortened to

=IF(Z4="","",IF(OR(Z4={"Defined","Fee"}),"Not Applicable")))

.