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 en...
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)
