Conditional fomatting

  • Thread starter Thread starter Sinfante
  • Start date Start date
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
 
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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top