ExcelBanter - View Single Post

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