I have a colum (say A) which has values, what I want in Colum B is depending
on the value in Column A assign a value in column B

The range for column A is
£0.99-£9.99
£10-£14.99
£15-£24.99
£25-£49.99
£50-£99.99
£100-£249
£250+

so, if column A is within 0.99 and 9.99 then Column B = 1.
and so on..
any help