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})
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})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks