Need to categorize continuous data

[Broccoli]

Hello,

I'm new so I hope I'm not already breaking a rule...

I'm trying to categorize continuous data so that if data in Column N are of certain values they are categorized in Column Q.... The catergories I'm looking for are:

If N is > or = 75 then it is "4"
If N is <75 but > or = 25 then it is "3"
If N is <25 but > 0 then it is "2"
and If N is = 0 then it is "1"

What I've tried (thanks to this forum!) in Q is:
[=IF(N2>=75,4,IF(25<=N2<75,3,IF(0<N2<25,2,IF(N2=0,1))))]

I get "4" where appropriate and everywhere else "FALSE" ... I've tried a few different variations of the above formula without much success... any help would be greatly appreaciated.

Thanks.... and thanks for this forum it has been of great help to me in the past!!!

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[Broccoli]

WOW!!!

That was fast! Thank you... That did it!!! Now I need to get familiar with the lookup function...

Thanks again!!!!