IF(P28="Yes",IF(W28<=V28,D28-V28,?),IF(P28="No",0,??))

You will have to fill in the ?'s. What do you want if W28 is greater than
V28 (?). What do you want if P28 is neither "Yes" or "No" (??)

Tyro

"heater" wrote in message news:513F2F6B
...
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.