...... or do you mean...

=if(OR(F14=value,G14=Value),H3+F13-G14),0)

i.e if F14 OR G14 Value?

If both F14 AND G14 = Value then change OR to AND

=if(AND(F14=value,G14=Value),H3+F13-G14),0)


HTH

"Horst" wrote:

Can someone give me the right formula plase
IF(F14:G14=VALUE,SUM(H13+F14-G14),0)