IF statement or
=MATCH(A2,{0.99,10,15,25,50,100,250})
flow23 wrote:
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
|