IF Formulas

[BSantos]

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

 

[Govind]

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.

 

[Sandy Mann]

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
[email protected]
[email protected] with @tiscali.co.uk

 

[BSantos]

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!

 

[BSantos]

Thank you that worked! :0)

Bonnie,

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
[email protected]
[email protected] with @tiscali.co.uk

 

[Sandy Mann]

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

--
Regards

Sandy
[email protected]
[email protected] with @tiscali.co.uk