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