IF Formula...????

[guins]

We are trying to compare two pricing models.

Short Course Fees
* Paying per users per month only

Last year we had 3750 paying users (D3)
Divided by 12 (months) equals 312.5 users per month
Monthly enrolments calculated as per D5 - F8 table

Leaner Tier Price Model
* Annual fee charged per tier
- from 3000 - 4000: 2801.70 (C17)
- from 4000 - 5000: 3257.65 (C18)

Our goal is to compare the two pricing models for a period of 4 months (August - November)

Aug - Sep Tab
Short Courses Fee
* F3 will be users in August
* F4 = F3 (probably just a duplication!!!)
* F5 - First 100 users cost
* F6 - Next 100 users cost
* F7 - Next 100 users cost
* F8- Remaining users cost
F10 - Total Monthly Cost

Learner Tier Pricing Model
* E17 = F4
* G17 = E17 * F17
H17 is where the help is needed please..............

If G17 is >3000 but less than 4000 = C17 / If G17 >4000 but less than 5000 = C18

Not sure if this all makes sense - happy to explain further if required

P.S. - I tried to use XL2bb but had no luck sorry

 

[Peter_SSs]

P.S. - I tried to use XL2bb but had no luck sorry

I suggest that you review the 'Known XL2BB issues' section near the start of the instructions. That (especially the icons greyed out one) resolves the problem for most people who are having trouble.