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),"")

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

Regards

Govind.

BSantos wrote:
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

Bonnie,

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

"BSantos" wrote in message
...
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

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!

"Govind" wrote:

Hi,

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

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

Regards

Govind.

BSantos wrote:
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

Thank you that worked! :0)

"Sandy Mann" wrote:

Bonnie,

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

"BSantos" wrote in message
...
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

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

--
Regards

Sandy

with @tiscali.co.uk
"BSantos" wrote in message
...
Thank you that worked! :0)

"Sandy Mann" wrote:

Bonnie,

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

"BSantos" wrote in message
...
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