Satisfying several criteria

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.
 
C

Colin Hayes

Gord said:
=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.
 
C

Colin Hayes

David Biddulph said:
=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
 

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

Top