View Full Version : excel formula

21-11-2007, 11:01 PM
I have a fee schedule for classes 1-12: Each year has a unique tuition fee. In addition there is a discount on the fees for siblings, 20% for 1st sibling, 40% for second and 75% for third and more.
I want to create a table in which I enter the number of children from any family against the classes the children will attend and the fees applicable to each child are automatically generated.
Any help with the appropriate formulae?

22-11-2007, 07:43 PM
I can't load an html image of the spreadsheet like you can on some forums and there are too many words - so I figured a picture might save me a thousand words:


The formulas are for the cells indicated and are designed to be copied down.


26-11-2007, 09:16 PM