Forum Discussion
If Then Formula help
Hi excel elite, I am trying to work out a formula: If cell K7 is 1, then F7 + 14, if cell K7 is 2, then F7 + 42, if cell K7 is 3, then F7 + 56. Thanks for your time! Annie
Could be like this:
=(K7=1)*(F7+14)+(K7=2)*(F7+42)+(K7=3)*(F7+56)
or
=IFS(K7=1,F7+14,K7=2,F7+42,K7=3,F7+56)
Just two examples. Same answer, different approach.
🙌🙌🙌 thankyou!