what if analysis

  • Thread starter Thread starter shaharul
  • Start date Start date
S

shaharul

say i offer 6 courses to 40 students, whom can enrol to any of th
courses. However, the cost of the course differ between one another an
depends on the student mix.

can anybody help me to prepare a what if analysis table to get the th
cost of each student and total cost involved based on various number o
student.

thanks in advanc
 
Hi Shaharul,

If I understand correctly, try this. I'm using 10 students and 2 courses in
my example.

In B2:B11 = 1 thru 10
In C2:C11 = $100, $90, $80 etc. down to $10
B2:C11 is named Course1

In D2:D11 = 1 thru 10
In E2:E11 = $111, $99, $88 etc. down to $11
D2:E11 is named Course2

In A16 = "Course" without "".
In B16 = either a 1 or 2.
In C16 = "=A16&B16" without ""
In D16 = the number of students in the course, 1 thru 10.
In E16 enter =VLOOKUP(INDIRECT(C16),2,0)*D16

So if B16 = 1 and D16 = 8 then E16 returns $240.
Now change B16 to 2 and the student number in D16 to 6.
Now E16 returns $330.

HTH
Regards,
Howard
 
Back
Top