I let holiday properties on different Holiday Parks; one of the Parks (let's call it "ABC Holiday Park") has a site pass fee which must be collected with the booking.
The charge is £12.00 for 1-4 people but for the 5th, 6th, 7th or 8th person (if applicable) it's an additional £3.00 per person.
I'm trying to write an IIf argument for this formula; however, I want the argument to return a value of £0.00 for all other Holiday Parks, that is those that don't charge a site pass fee.
So far, I've created the following:
=IIf([Holiday Park]="ABC Holiday Park",IIf([Occupancy]<=4,"£12.00",IIf([Occupancy]>=5,[Occupancy]*3,"£0.00")))
It works fine as far as all bookings for ABC Holiday Park are concerned but doesn't return a £0.00 for those non-site pass fee parks.
Can anyone help please ?