Apply sum only if both columns don't equal 0 or blank

[Kelli Webb]

Hello,

I know this is probably excel 101, but I can't crack it.

If Column A and Column B <> 0 or "", sum(Column A - Column B),0)

The desired result is in column C.

thank you and stay safe!

Kelli

 

[vletm]

Kelli Webb
=IF(AND(A2<>0,B2<>0),A2-B2,0)

 

[pecoflyer]

Or, back to basics
=(A2<>0)*(B2<>0)*(A2-B2)