MS Excel help

[Aero]

ok, using excel 2003 and need help, its been sooooo long since i've used it last.

i have a system set up where, through drop down menus, the user selects multiple variants, its for business contracts, anyways, i'll give a few variants to explain what i need done -

1 you select the tariff which links to a price

2 you select number of handsets required

3 you select the length of the contract.

number 3 is the key here as, thelonger the contract is the greater the discount you get.

im trying to output all this in a printable sheet which breaks down cost per month, cost per handset etc

HERES THE PROBLEM

i need a way of subtracting a changeable percentage from a changeable price eg

[Fozy]

I'll try tonight I was doing that in college.

[Aero]

cheers, something this simple should be easy to do, i think im missing something obvious lol

[Fozy]

Can't you just get relative um, forget the word. But what you do is have a list of prices with the percentage next to it, e.g.

50 - 60 5%

61 - 100 10%

And just correspond that to the field you need. Get me? I completely forget how to do it though, I'll give it a shot.

[Aero]

thanks for the help iain.

sorted now, topic closed!