Feb 18 2019 07:47 AM
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
Feb 18 2019 08:53 AM