Try this:

=IF(P28="no",0,IF(AND(P28="yes",W28=V28),D28-V28,IF(AND(P28="yes",W28<V28),D28-W28,0)))

--
Biff
Microsoft Excel MVP


"heater" wrote in message
...
I have the following formula, which does not work
=IF(OR(P28="Yes"),AND(W28=V28,D28-V28),OR(W28<V28,D28-W28,IF(P28="no",0))).
What I need is as follows:

If P28 is "Yes" and IF W28 is equal to V28, then D28 Minus V28, OR If P28
is
"Yes" and W28 is less than V28, then D28 Minus W28, If P28 is "No", then
0.