PDA

View Full Version : excel formula



bpt2
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?

andrew93
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:

http://www.imagef1.net.nz/files/XL.jpg

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

Andrew

bpt2
26-11-2007, 09:16 PM
Thanks