Multiplying a number over a certain range

[smetcalfe]

Hi guys

Another query

If i had a total of 100 apples and the price was £40 and the price is £40 for however how many apples below 100. But once over 100 apples its 0.20p per apple.
How would i put that as a formula?

Many Thanks Guys

[Fotis1991]

Perhaps

=IF(A1<=100,A1*40,((A1-100)*0.2)+A1)

[Special-K]

Given a value x indicating a quantity of apples

The amount over 100 would be (x-100)
So

IF(x < = 100, x*40.00, 40*100+(x-100)*0.02)

Postscript: Apples are £40 each??????? Blimey, remind me not to go to your greengrocers! :-)

[smetcalfe]

Not working as it should be £40.00 however many under 100.

Cheers

[Fotis1991]

Do you mean?

=IF(A1<=100,40,((A1-100)*0.2)+A1)