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