I would like to ask how could I insert a function in that yellow cell by following the conditions where if the type is from A-D and either it is "Standard" or "Premium", then it will display the calculated price according to the rate?
For example, when I type in D3 with "A" and E3 with "Standard", then it will automatically show the price of 800 as calculated at the right side of the picture in F3.
Thanks in advance!! :)
Aucun commentaire:
Enregistrer un commentaire