• 464K Members
• 11.6K Online
• 560K Conversations

New Contributor

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

3 Replies

Re: not sure what formula to use

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)

Re: not sure what formula to use

Thank you so much. this works perfectly.

Re: not sure what formula to use

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies