IF function in Excel

Occasional Visitor

I have a cell (D7) using a drop down list of numbers 1,2,3,4,5,6,7,8,9,10,11,12,13

 

Is it possible to use the IF function to return 1 value in another cell (F7) if 1,2 or 9 is selected and another value in the same cell (F7) if 3,4,5,6,7,8,10,11,12 or 13 is selected.

 

IF 1,2 or 9 is selected in D7 I want F7 to be 0

IF 3,4,5,6,7,8,10,12,12 or 13 is selected in D7 I want F

1 Reply

@IanCCS Try this:

=IF(OR(D7={1,2,9}),0,"F")