Excel

[Bob Lane]

How do you write a fomula to show a different price in
colum F when you change what you put in colum E, eg

If I type 3mm in column E then column F shows £12.50,
if I type 4.5mm column F to show £17.50, and if I type 6mm
in column E, column F to show £27.50 and so no 9mm=£36.45,
12mm=£41.20, 15mm=£45.00. All in the same cell
I have writern a formula but Column F shows £12.50 for the
3mm but then £017.50 for the 4.5mm
and £0027.50 for the 6mm.

What am I doing wrong

Hope you can help


Bob Lane

 

[Myrna Larson]

You're writing the formula incorrectly (obviously <g>), but you didn't show what you wrote. I
suggest you use a table and VLOOKUP. The 3, 4.5, 6, 9, 12, and 15 go in the 1st column, the
corresponding prices in the column to the right. See Help for more information on VLOOKUP.