What formula can I use
 

I am analyzing a cloumn of data which consist of 400 records. I'd need
to classify the records into 4 groupings A,B,C, and D. I used the "IF"
formula to return a value of "A" for all of the records that meet the
"A"criteria. How can I get my formula to do the same for records that
are in the B,C, and D groupings? Thanks:)


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=510165

What formula can I use
 

=IF([Your criteria for A],"A",IF([Your criteria for B],"B",IF([Your
criteria for C],"C",IF([Your criteria for D],"D","FALSE"))))

[Your criteria for A] would be whatever you are using to break the data
into
different categories (e.g. A11000)

Is this what you are looking for?


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510165

What formula can I use
 

How would I be able to make my criteria use a range of numbers. Ex I
want to classify all B's as acounts that are greater than 1 but less
than 5, and all C's would be accounts that are greater than 5 but less
than 10. Thanks so much for any help.


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=510165

What formula can I use
 

Referring to my previously posted formula for [your criteria for A]
etc.
you would use an AND function which works like this:

AND(criteria1,criteria2)

so if you wanted to classify it as "B" the function would be:

AND(A11,A1<5)

and for C:

AND(A15,A1<10)

where A1 is your account.

Note that B is less than 5 and C is greater than 5, it will not
recognize any
account that is exactly 5 so you should use <= or = depending on your

situation.

Let me know if you need anything else.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510165