Ok - I can figure out basic functions, but this one is confusing. Here's my problem - there is 2 IF formula's needed
It's a spreadsheet to track a contest.
1st formula needed: For your first $12,500 AP during the contest
period, you earn 1 ticket. For every $3,000 AP
above the initial $12,500 during the contest
period, you earn another ticket.
I need to have it calculate how many tickets a person gets from the sum of their AP. I have the total calculating already.
2nd one is: For each week in the contest period that your
district achieves:
150% of MPI, you will receive 1 ticket
200% MPI – you earn 3 total tickets for that
week!
This one is even more confusing... MPI is our name for our quotas.
I am not sure how to do the formula. Would someone please show me what it would be? Then I can figure it out for the future ones. Thank you.
Bookmarks