Satisfying several criteria

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

Hi All

I'm trying to write a formula to satisfy this criteria :

If A1+B1 > 0 then put A1+B1 , otherwise leave blank.

BUT if C1 has content , put "0.00".


Can someone help with a formula to include these parameters?

Grateful for any help.
 
Gord said:
=IF(C1<>"",0,IF(A1+B1>0,A1+B1,""))
Click to expand...

Hi Gord

OK Thanks for that. It's working fine , but is prioritising results in
the opposite way to what is intended.

By which I mean :

The formula concerning C1 should only have effect if the A1+B1 part of
the formula gives a blank cell.

So ,

If A1+B1 > 0 then put A1+B1

If A1+B1 < 0 then leave blank.

IF A1+B1 is now blank , and C1 has content then insert '0.00'

IF A1+B1 is now blank , and C1 has NO content then leave blank.


Complicated , but can you turn your formaula to satisfy this?

Grateful for your help.
 
David Biddulph said:
=IF(A1+B1>0,A1+B1,IF(C1<>"",0,""))

David Biddulph
Click to expand...

Hi David

OK thanks for this. It works perfectly.

I'm grateful for your time and expertise.


Best Wishes
 
Back
Top