Hello,
I am trying to create a formula to do the following:
By choosing the number of passengers and then choosing the "Type of Adult" from the list below, to calculate the base fee them multiplied by the amount number of Adults. Example would be below:
Gate Fees
Intl Adult R700,00 Intl Child R312,00
SADC Adult R300,00 SADC Child R205,00
SA Adult R500,00 SA Child R200,00
Type of Game Drive Number of Adults Type Of Adult Adult Gate Fees Number of Children Type of Child Child Gate Fees
Shared Morning Drive 1 Intl Adult 1
Shared Afternoon Drive
Shared Full Day Drive
Each of the "Types" would be a drop down list and then trigger the calculation. Hope this makes sense.
Bookmarks