If..Formula needed please

**stevedork** · 06-22-2009, 06:02 PM

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

**mikerickson** · 06-22-2009, 06:05 PM

How about something like

=A1-CHOOSE(A2,.75,12.5,value3,value4)+CHOOSE(A2,12,40,pounds3,pounds4)

**shg** · 06-22-2009, 06:57 PM

Steve, please take a few minutes to read the forum rules, and then amend your thread title accordingly.

**rwgrietveld** · 06-23-2009, 07:32 AM

If found the following solution:

Please Login or Register  to view this content.

**stevedork** · 06-23-2009, 07:39 AM

Brilliant, thank you so much
Regards
Steve

**squiggler47** · 06-23-2009, 07:41 AM

=CHOOSE(Zone,(Weight-15)*0.5 +12,(Weight-10)*1.25 +40,"Formula 3","Formula 4")

**DonkeyOte** · 06-23-2009, 07:42 AM

Steve please read the Forum rules before posting any further.

The title remains unacceptable - think along the lines of what you would enter into a Search Engine when giving a title to your thread.

rwgrietveld / squiggler47 - going forward please consider as to whether or not the alteration made by the OP is in line with the rules before posting...