How to use a nested IF statement

[merQrey]

Hi Guys

i was hoping someone can offer me some assistance on the following problem. im not sure if i using the IF Statement is the correct way to tackle this problem but basically i need a sheet in excel that can calculate the following

if for instance i have Column A that has a list of figures, for instance, one A1 = 250, A2 = 500, A3 = 5800
i need Column B to calculate an amount based on the following parameters

R 0.01 to R 250.00 = 5% of the number in Column A1 for instance
R 250.01 to R5,000.00 = R12.50 + 4% of the number over 250 (A2 - 250 = 250 x 4% + 12.50)
R5,000.01 to R100,000.00 = R202.50 + 3.5% of the number over 5000 (A3 - 5000 = 800 x 3.5% + 202.50)

can this be done?

[FDibbins]

Thanks for the change

Hoe gaan dit daai kant van die groot dam? SA ex=pat here from PE and Klerksdorp

Try this for what you want...
=IF(A1>5000,202.5+(A1-5000)*0.035,IF(A1>250,12.5+(A1-250)*0.04,A1*0.05))