IF formula

[stevedork]

I hope I have done it correctly this time...
So sorry to bother you all again, but here is my problem....
On a workbook I need to put in a weight (cell A1) then in cell A2 I need to put in a zone (1 , 2 , 3 or 4) then in cell A3 I need to show the following:
if Zone =1 then A3 = (A1)-15 x 0.5 + £12.00
if Zone =2 then A3=(A1) -10 x 1.25 +£40.00
and so on for all 4 zones
can anyone spare the time please...
thanks in anticipation
Steve

[DonkeyOte]

Steve, no need to create a new thread simply just edit the title of the existing one please...

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.