Hi,

I thought the formula below would give me the result of:

7 if I5=1
6 if I5=2
5 if I5=3 and so on but it doesnt seem to work. Can anyone help with where I am going wrong?

=IF(OR(I5={1,2,3,4}),{7,6,5,4})