I'm trying to write a formula with the following data using Excel '03:

If a student is tardy once, then it costs him $100. Twice, then it costs
him $200 and the previous $100 and $200 need to be added to show that it cost
him $300 total. If a student is tardy three times, then it costs him $300,
plus the previous $100 and $200, for a grand total of $600. I would like
this formula to go up to ten tardies and not use Visual Basic. or tables.

Thank you!

Steve