Forum Discussion
Solved
Excel
I need a formula that enters a value in one cell based on another. The entered value can be any one of five numbers i.e. If I enter 3 in cell A1, the adjacent cell A2 should display 3 or if I enter 4...
=IF(A1=3,3,IF(A1=4,2,IF(A1=5,1,IF(A1=1,5,IF(A1=2,4,"")))))=CHOOSE(A1,5,4,3,2,1)In cell A2 you can try any of these formulas.
=IF(A1=3,3,IF(A1=4,2,IF(A1=5,1,IF(A1=1,5,IF(A1=2,4,"")))))=CHOOSE(A1,5,4,3,2,1)In cell A2 you can try any of these formulas.
thank you for your suggestions and helpful tips. The first formula worked a treat. Just had to tweak it a little to add more numbers. Perfect, thanks again.