IF statement or
 

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

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

IF statement or
 

You want the general form:

=IF(AND(A1=.99,A1<=9.99),1,IF(AND(A1=10,A1<=14.9 9),2,IF(....))


Dave

--
Brevity is the soul of wit.


"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