Multiple formula options in cell

[FROGGER24]

In cell N1 if the value is A,B,C,D then use formula 1,if N1 = 2 use formula 2, if N1=3 use formula 3, if n1 =4 use formula 4, if n1 =5 use formula 5, if n1= 6 use formula 6, if n1 = 7 use formula 7.

Thanks in advance for any help provide.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1083787-multiple-formula-options-cell.html#post5207621

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).