Hi All,
I am trying to figure something else, but I'm all lost for ideas.
I have a form with three criteria
- Cost per attendee
- Cost of venue
- Additional costs
what i have set up is I've made 3 tick boxes adjacent to the form files called:
- gst 1
- gst 2
- gst 3
What i want to do it calculate the interest (10%) on each criteria
these are the examples if had for the first criteria:
- =IIF([Cost per attendee]*1.1, [GST1]="TRUE", [GST1]="FALSE"
- =IIF([GST1]="TRUE",[Cost per attendee]=[Cost per attendee]*1.1)
can anyone give me some advice?
thanks