Multiple condition formula help needed

[Alex D]

I am having a really hard time trying to write a formula in column E....what I am trying to do is have the formula look at D, first, and based on what is in D, then either look at B or C...I wrote my desired result in the cells in Column E...I also want to see blanks if either D, B or C are blank, but it has to start with a look at D first, then from there B or C but have blanks if needed

 

[Z51]

Try:

=IF(D9="ICR",IF(B9="","",IF(B9>30,0,1)),IF(D9="RESI",IF(C9="","",IF(C9>30,0,1))))

 

[Fluff]

How about

=IF(D9="ICR",IF(B9="","",IF(B9>30,0,1)),IF(D9="RESI",IF(C9="","",IF(C9>30,0,1)),""))