H
heater
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.
=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.