Conditional fomatting

S

Sinfante

I am trying to write a formula for cell D2 that is
=B2-C2 but only if C2 has data entered or maybe if C2 is greater tha
0

I have tried different variations on this
=B2-C2,SUMIF(C2>0)
but I keep getting errors with the 0

I am trying to get a buget with carryover overages or underages
i.e.
B2= budgeted amount
C2= actual spent
D2= overage or underage

I would appreciate any help you can give. Thanks in advanc
 
M

Max

I am trying to write a formula for cell D2 that is
=B2-C2 but only if C2 has data entered
or maybe if C2 is greater than 0
Click to expand...

Try in D2: =IF(OR(ISBLANK(C2),C2<=0),"",B2-C2)
 
Top