On Thu, 10 Jan 2008 10:12:02 -0800, 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.


In your explanation in the 2nd paragraph, your "OR" does not make sense to me.
Perhaps you really mean "ELSE" ??

If so, then I believe this will do what you describe:

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

You realize, of course, there are logically possible conditions which are
unspecified. They will return FALSE.
--ron