Annie_MansfieldCopper ContributorJan 16, 2020If 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 Show More
SergeiBaklanDiamond ContributorJan 17, 2020Annie_Mansfield One more =F7+ ( (K7=1)+(K7+1)*( (K7=2)+(K7=3)))*14
