
IF function with drop down list variables
I am trying to create a formula for a function with an input for height but the output dependent on gender. I have the formula for the male option in C1 and the formula for female input in D1. Is there anyway to have this combined so the output will show in B3 and allow me to delete C1 and D1?
https://docs.google.com/spreadsheets/d/1Z3bqi88wISUou3w5WwU3hczogQjafwnGJTGwWabJxSU/edit?usp=sharing