Satisfying several criteria

[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]

=IF(C1<>"",0,IF(A1+B1>0,A1+B1,""))


Gord Dibben Microsoft Excel MVP

 

[Colin Hayes]

=IF(C1<>"",0,IF(A1+B1>0,A1+B1,""))

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]

=IF(A1+B1>0,A1+B1,IF(C1<>"",0,""))

David Biddulph

 

[Colin Hayes]

=IF(A1+B1>0,A1+B1,IF(C1<>"",0,""))

David Biddulph

Hi David

OK thanks for this. It works perfectly.

I'm grateful for your time and expertise.


Best Wishes