Snake,
You need to post this in the Excel.Programming group
Boy, I'm glad I left the UK! Fines of £50 for every 1 mph over the limit
So you are 10 mph over the limit and the fine is £500+£112 (that $930)
Bernard


"Snake" wrote in message
...
Hi, I'm learning excel on my own and would love someone's help with this
problem that I've got. I wouldn't mind if its a couple of helpful remarks
or
a full solution. I thank you very much either way.

The problem is:

You have been hired to work for a local magistrates court. The clerk of
the
court needs a spreadsheet that will calculate speeding fines that need to
be
paid by offenders. The worksheet must contain the following information

 Legal speed limit
 Speed offender was traveling
 Number of miles per hour the offender was traveling above the speeding
limit
 Number of previous speeding offenses
 Total cost of the fine

Some of these values will be calculated, others will be entered by the
user.
Speeding fines are calculated using the following assumptions:-
 £50 fine for each mile per hour above the legal speed limit
 Court costs of £112.50 [this is a fixed amount]
 Additional charges [£75 for each previous offense]

Add a command button labeled New Case. The button should clear the
worksheet
of all data in order for a new case to be entered, then presents a series
of
Input Boxes. Each input box should ask the user to enter the following:-
 Name of the offender
 Legal speed limit in the area
 Speed the offender was traveling
 Number of previous speeding offenses.


Would love ur comments thanks.