Working out figures to a value

[Nicky_B]

Hi,

Rubbish at Excel hence the need for help.
Basically if I have a cell that has a 1 entered into it I want the cell next door to it to show a value in pounds of £23.50. If the cell has a 2 entered into it I want the cell next door to show a value in pounds of £47.00. So basically for each increase of 1 the cell next door goes up by an additional £23.50.
Please show me how to do this. Thanks you in advance. I have attached an excel sheet as a guide to what I am trying to achieve.

[Glenn Kennedy]

Do you mean:
=E8*23.5