FORMULA NOT WORKING

[Guest]

Help! The below formula and many others is not doing what
I need it to do and I'm over the edge trying to figure it
out. Hopefully, you can help me, you usually do.

I'm trying to achieve the following--If C15 is greater
than B15 and D27 plus D31 is greater than 0, result is -
C16 only if it is 20% or less of B15 or 200,000, whichever
is less otherwise result is 0 OR If C15 is less than B15
and D27 plus D31 is greater than 0, result is -C16 only if
it is 20% or less of B15 or 200,000, whichever is less
otherwise result is 0


=IF(AND(C15>B15,D27+D31>0)*AND(C15<B15,D27+D31>0),IF(-
C16>B15*0.2>200000,200000,B15*0.2)*C16,0)

 

[Frank Kabel]

Hi
try
=IF(OR(AND(C15>B15,D27+D31>0),AND(C15<B15,D27+D31>0)),IF(-
C16>MIN(B15*0.2,200000),0,-c16),0)

or a little bit shortened:
=IF(AND(D27+D31>0,C15<>B15),-C16*(-C16<MIN
(B15*0.2,200000)),0)

or even shorter:
=-C16*(D27+D31)*(C15<>B15)*(-C16<MIN(B15*0.2,200000))

 

[Guest]

Mr. Frank, YOU ARE THE BEST!!!!!!!!!! Thank you thank you
thank you!!!!!!!!!!!!