Formula Help

[PeterK]

I have a formula that I want to add too.
=IF(AND(F4>D4,L4>0.33,M4>79%),SUM(D4-E4)*0.015,"0")

I want to also another criteria in that L4 is 0 and N4 is greater tha
80 in addition to the first. So that L4>0.33,M4>79% is one criteri
and L4=0,N4>80% is the other.

Thanks
Pete

 

[Biff]

Hi Peter,

What do want to associate the new criteria with? The AND
function? If so, you have a problem in that L4 is already
defined as >0.33. If you add L4=0, then the formula will
return 0 as L4 cannot be >0.33 and =0 at the same time. Or
do want the new criteria, L4=0,N4>80%, to be seperate from
the first group of criteria if it evaluates to false? If
that's the case try this:

=IF(AND(F4>D4,L4>0.33,M4>79%),(D4-E4)*0.015,IF(AND
(L4=0,N4>80),(D4-E4)*0.015,0))

Biff