Forum Discussion

joanneosp's avatar
joanneosp
Copper Contributor
Feb 18, 2019

not sure what formula to use

I need some help working out a formula

 

I have a drop down box which has the options : Per person, total cost and no cost

There is then a box to enter cost

Up the top of the page are cells to enter number of children/adults

 

I then want the totals cell to calculate:

IF Per person is selected then it will show the cost x the total amount of people 

OR

IF total cost is selected then times the cost cell by 1

OR 

IF no cost is selected then return the value 0

excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Feb 18, 2019
    Assuming number of persons is in A1, Cost is in B1, and drop-down is in A2, the formula in B2 is:
    =CHOOSE(MATCH(A2,{“Per Person”,”Total Cost”,”No Cost”},0),A1*B1,B1,0)

Resources