Range formula.

[avisoft20]

Dear Excel Expert
i have some problem in range formula.
i am using this but its not working
=IF(aa<200,"S4",IF(A1<500,"S3",IF(A1<1000,"S2",IF(A1<1500,"s1","A"))))

I am trying for
if
Column A is equal and greater than=1500 then its give First.
Column A is greater than and equal to=1000 and less 1499 then its give Second.
Column A is greater than and equal to=500 and less 999 then its give Third.
Column A is greater than and equal to=200 and less 499 then its give Fourth.


Thanks
Avinash

 

[codeliftsleep]

aa isn't a range...

I'm assuming it should be A1

 

[avisoft20]

Sorry By Mistake its a1 not "aa"

 

[Ron99]

Hi,

This formula should work - =IF(A1>=1500,1,IF(AND(A1>=1000,A1<1500),2,IF(AND(A1>=500,A1<1000),3,IF(AND(A1>=200,A1<500),4))))

provided the value is in column A.

 

[avisoft20]

Thanks i made it and its working
here
=IF(A1>=1500,"Slab-1",IF(A1>=1000,"Slab-2",IF(A1>=500,"Slab-3",IF(A1>=200,"Slab-4","N/A"))))

 

[Aladin Akyurek]

This kind of stuff implies a look up set up...

Either:

=LOOKUP(A1,Table)

where Table consists of 2 colums:

0	N/A
200	Slab-4
500	Slab-3
1000	Slab-2
1500	Slab-1

<tbody>
</tbody>

Or a hard-coded table in the formula:

=LOOKUP(A1,{0;200;500;1000;1500},{"N/A";"Slab-4";"Slab-3";"Slab-2";"Slab-1"})

 

[avisoft20]

hi Ron
thank you for the reply but there is a mistake in question,

Dear Excel Expert
i have some problem in range formula.

=IF(A1>=1500,1,IF(AND(A1>=1000,A1<1500),2,IF(AND(A1>=500,A1<1000),3,IF(AND(A1>=200,A1<500),4))))
and one more row i.e a2=15%

I am trying for
if
Column A is equal and greater than=1500 and a2 is more than-15% then its give First.
Column A is greater than and equal to=1000 and less 1499 and a2 is more than-15% then its give Second.
Column A is greater than and equal to=500 and less 999 and a2 is more than-15% then its give Third.
Column A is greater than and equal to=200 and less 499 and a2 is more than-15% then its give Fourth.


Note : changes is in RED FONT .

Thanks
Avinash

 

[Aladin Akyurek]

See post #6 ...