software

Can someone help with this an if formula.

I need to write a formula that for example:

If A1 = 0 give me b1, but if b1 = 0 also give me c1 otherwise give me d1-a1

I don't know how to write this. I thought I did but it's not working.

If (A1=0,b1,if(b1=0,c1,(d1-a1)

Help! Bonnie

Hi,

=IF(A1=0,IF(B1=0,C1,D1-A1),quot;quot;)

You havent specified what you need if A1 is not equal to 0, so am
returning a blank.

Regards

Govind.

BSantos wrote:
gt; Can someone help with this an if formula.
gt;
gt; I need to write a formula that for example:
gt;
gt; If A1 = 0 give me b1, but if b1 = 0 also give me c1 otherwise give me d1-a1
gt;
gt; I don't know how to write this. I thought I did but it's not working.
gt;
gt; If (A1=0,b1,if(b1=0,c1,(d1-a1)
gt;
gt; Help! Bonnie

Bonnie,

gt; If (A1=0,b1
If A1 = 0 the formula returns B1 and is satisfied and so it does not matter
what else is in the formula.

Try:

=IF(AND(A1=0,B1=0),C1,IF(A1=0,B1,D1-A1))

--
HTH

Sandy
with @tiscali.co.uk

quot;BSantosquot; gt; wrote in message
...
gt; Can someone help with this an if formula.
gt;
gt; I need to write a formula that for example:
gt;
gt; If A1 = 0 give me b1, but if b1 = 0 also give me c1 otherwise give me
gt; d1-a1
gt;
gt; I don't know how to write this. I thought I did but it's not working.
gt;
gt; If (A1=0,b1,if(b1=0,c1,(d1-a1)
gt;
gt; Help! Bonnie
Thank you... but it still doesn't take into account that if

A1=0 give me what is in cell b1. But, if b1 is also 0 than give me what is
in cell c1 otherwrise if a1 is not 0 give me d1-a1

Sorry if that is confusing! Thanks for any help!

quot;Govindquot; wrote:

gt; Hi,
gt;
gt; =IF(A1=0,IF(B1=0,C1,D1-A1),quot;quot;)
gt;
gt; You havent specified what you need if A1 is not equal to 0, so am
gt; returning a blank.
gt;
gt; Regards
gt;
gt; Govind.
gt;
gt; BSantos wrote:
gt; gt; Can someone help with this an if formula.
gt; gt;
gt; gt; I need to write a formula that for example:
gt; gt;
gt; gt; If A1 = 0 give me b1, but if b1 = 0 also give me c1 otherwise give me d1-a1
gt; gt;
gt; gt; I don't know how to write this. I thought I did but it's not working.
gt; gt;
gt; gt; If (A1=0,b1,if(b1=0,c1,(d1-a1)
gt; gt;
gt; gt; Help! Bonnie
gt;

Thank you that worked! :0)

quot;Sandy Mannquot; wrote:

gt; Bonnie,
gt;
gt; gt; If (A1=0,b1
gt; If A1 = 0 the formula returns B1 and is satisfied and so it does not matter
gt; what else is in the formula.
gt;
gt; Try:
gt;
gt; =IF(AND(A1=0,B1=0),C1,IF(A1=0,B1,D1-A1))
gt;
gt; --
gt; HTH
gt;
gt; Sandy
gt;
gt; with @tiscali.co.uk
gt;
gt; quot;BSantosquot; gt; wrote in message
gt; ...
gt; gt; Can someone help with this an if formula.
gt; gt;
gt; gt; I need to write a formula that for example:
gt; gt;
gt; gt; If A1 = 0 give me b1, but if b1 = 0 also give me c1 otherwise give me
gt; gt; d1-a1
gt; gt;
gt; gt; I don't know how to write this. I thought I did but it's not working.
gt; gt;
gt; gt; If (A1=0,b1,if(b1=0,c1,(d1-a1)
gt; gt;
gt; gt; Help! Bonnie
gt;
gt;
gt;

You're welcome, glad that it worked for you.

--
Regards

Sandy
with @tiscali.co.uk
quot;BSantosquot; gt; wrote in message
...
gt; Thank you that worked! :0)
gt;
gt; quot;Sandy Mannquot; wrote:
gt;
gt;gt; Bonnie,
gt;gt;
gt;gt; gt; If (A1=0,b1
gt;gt; If A1 = 0 the formula returns B1 and is satisfied and so it does not
gt;gt; matter
gt;gt; what else is in the formula.
gt;gt;
gt;gt; Try:
gt;gt;
gt;gt; =IF(AND(A1=0,B1=0),C1,IF(A1=0,B1,D1-A1))
gt;gt;
gt;gt; --
gt;gt; HTH
gt;gt;
gt;gt; Sandy
gt;gt;
gt;gt; with @tiscali.co.uk
gt;gt;
gt;gt; quot;BSantosquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Can someone help with this an if formula.
gt;gt; gt;
gt;gt; gt; I need to write a formula that for example:
gt;gt; gt;
gt;gt; gt; If A1 = 0 give me b1, but if b1 = 0 also give me c1 otherwise give me
gt;gt; gt; d1-a1
gt;gt; gt;
gt;gt; gt; I don't know how to write this. I thought I did but it's not working.
gt;gt; gt;
gt;gt; gt; If (A1=0,b1,if(b1=0,c1,(d1-a1)
gt;gt; gt;
gt;gt; gt; Help! Bonnie
gt;gt;
gt;gt;
gt;gt;