Variable discount rate

[SyntaxSimon]

Hello all,

I'm pretty new to excel and have a few areas I need some help in.

I'm trying to calculate the cost of data transfer dependent on size using IF statements preferably in a single cell. These numbers aren't exact as I don't have the details to hand but you get the picture.

Every package will cost a minimum of £16 for initial upload and transfer up to 5GB. Above 5GB I want to charge the initial upload minimum of £16 plus £0.50 for every additional GB up to 50GB. Above 50GB again the initial charge of £16 plus £0.25 for every GB up to 100GB. Any transfer over 100GB will be a fixed cost of £100.

Rates and range
0 - 5 = £16
5 - 50 = £0.50
50 - 100 - £0.25
>100 = £100

Example
25GB
5GB Initial upload and transfer = £16
20GB Remaining multiplied by £0.50 = £10
Cost = £26

I would be very grateful for some help.

[dedevagilijus]

(Take in note x = A1 or any other cell, which contains data transfer value)
IF( x > 100; 100; ( IF( x <= 5; 16; IF( x <= 50; 16+(x-5)*0.5; 16+(x-5)*0.25) ) ) )

[SyntaxSimon]

Thanks for your help. Much appreciated.