I have a drop list in D24, you can choose between Junior, Mid and Senior.
I want E24 to have a different value depending on the choice. Junior= 21.43€ , Mid= 28.57€ , Senior= 35,71€
Then, I want to calculate my total amount depending on the number of people, rate and day. (people x rate) x Days
How do I do?