Formula help

[Alex D]

Trying to write a formula, but having a really hard time. I want to do the following...

If the first cell says, Commercial, then I want it to look at the second cell (# there now is 32) and if that value is less than 30, give me a 1 if not a 0, and if the first cell is NOT commercial, then look at 3rd cell (# there now is 29) and if that value is less than 30 give me a 1 if not a 0. on top of this, i want an iferror to show me blank.....

Commercial

32​

29​

 

[Sufiyan97]

Here is what I am after.....

First cell says: Commercial or Residential (never blank)

I want my formula, to look up the first cell, and if it's Commercial, go to the second cell, and if that value is less than 30, then give me a 1, if not a 0, but also look to see if second cell is blank, and if so, return the blank

Scratching my head on this