On Jan 10, 10:12*am, heater wrote:
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..

You could just formulate it exactly as you wrote it, namely:

=if(and(P28="yes",W28=V28), D28-V28, if(and(P28="yes",W28<V28), D28-
W28, 0))

Note: That returns zero even P28="yes", but W28V28, as well as when
P28 is "no". You neglected to cover that condition. So it is unclear
exactly what you want.