Hi,

I'd like help writing a single formula that assigns either a numerical 1 or 0 to a cell based on values from two other cells.

By way of background, I'm working with three columns. Cells in column F contains values from 1 to 4. Cells in column G contain values from 5 to 11. Cells in column H are currently blank.

I need a single formula that will insert either a numerical 1 or a 0 into column H according to the following conditions.
  • If F3 = 1 and G3 = 5 or 6 or 7 then let H3=1 otherwise let H3=0
  • If F3 = 2 and G3 = 7 or 8 or 9 then let H3=1 otherwise let H3=0
  • If F3 = 3 and G3 = 9 or 10 or 11 then let H3=1 otherwise let H3=0
  • If F3 = 4 and G3 = 9 or 10 or 11 then let H3=1 otherwise let H3=0
I'd appreciate any help.

Cheers,

Dougal