Satisfying several criteria
 

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.

Satisfying several criteria
 

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


Gord Dibben Microsoft Excel MVP


On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes
wrote:



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.

Satisfying several criteria
 

In article , Gord
writes
=IF(C1<"",0,IF(A1+B10,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.





Gord Dibben Microsoft Excel MVP


On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes
wrote:



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.

Satisfying several criteria
 

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

David Biddulph

On 10/09/2011 18:29, Colin Hayes wrote:
In article , Gord
writes
=IF(C1<"",0,IF(A1+B10,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.





Gord Dibben Microsoft Excel MVP


On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes
wrote:



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.

Satisfying several criteria
 

In article , David Biddulph
writes
=IF(A1+B10,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



On 10/09/2011 18:29, Colin Hayes wrote:
In article , Gord
writes
=IF(C1<"",0,IF(A1+B10,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.





Gord Dibben Microsoft Excel MVP


On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes
wrote:



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.