multiple ifs

[AbbyK]

hi

i'm tying to create a formula that checks a cell and if it's blank checks another cell an if it blank again checks another cell -

simply put i have D2 which is email address - if this is full i want to know its email but if it blank i want to check A2 which is home number- if this is blank then i want to check B2 which is mobile number etc- if all cells are blank i want to return the value dead

i've tried using

=IF(D2>0,"EMAIL",(IF(A2>0),"HOME",(if(B2>1),"MOBILE",(if(C2>1,"WORK","DEAD"))))

but it's not working- can some one help?

 

[Dryver14]

This should do it

=IF(D2>0,"EMAIL",IF(A2>0,"HOME",IF(B2>1,"Mobile",IF(C2>1,"WORK","DEAD"))))

 

[AbbyK]

thanks!!