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