Good afternoon all,
I am trying to model the following:
My company is offering to deliver a course for a school. We want to offer different levels of profit share depending upon how many students they can sign up. So we want to offer them 20% for the first 10 students, 25% for the 11-15th students and 30% for any 16 and above.
Can any of you help me with the equation that would capture this? I'm sure it's a rather easy function. I just can't seem to figure it out.
A million thanks!
James
Hi and welcome to the forum
This sounds fairly easy, using 3 nested IF()'s maybe, with your data in A1, something like...
=A1*0.8+IF(A1>10,(A1-10)*0.95,IF(A1>15,(A1-15)*0.95,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Assume your list of students in Column A. Assume your tuition is in G1. In B1, type this formula
=IF(COUNTA(A1:A30)<=10,0.2*G1,IF(AND(COUNTA(A1:A30)<16,COUNTA(A1:A30)>10),0.25*G1,0.3*G1))
EDIT: FDibbins types faster. Two good alternatives for you.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks