software

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 quot;IFquot;
formula to return a value of quot;Aquot; for all of the records that meet the
quot;Aquot;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: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=510165
=IF([Your criteria for A],quot;Aquot;,IF([Your criteria for B],quot;Bquot;,IF([Your
criteria for C],quot;Cquot;,IF([Your criteria for D],quot;Dquot;,quot;FALSEquot;))))

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

Is this what you are looking for?--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=510165
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: www.excelforum.com/member.php...oamp;userid=25034
View this thread: www.excelforum.com/showthread...hreadid=510165
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 quot;Bquot; the function would be:

AND(A1gt;1,A1lt;5)

and for C:

AND(A1gt;5,A1lt;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 lt;= or gt;= depending on your

situation.

Let me know if you need anything else.--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=510165