May 04 2022 02:27 AM
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