Activity: Excel – Drop Down boxes

The general format of an IF statement is. If(logical_test,value_if_true,value_if_false) In our example the formula should be this: =IF(G2=1,”M”,”F”) Be aware that we could have a nested IF statement and that if we do, our catch all, default condition comes as the last argument of the nested IF. Missing values ................
................