What formula can I use

P

petevang

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:)
 
M

mphell0

=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. A1>1000)

Is this what you are looking for?
 
P

petevang

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.
 
M

mphell0

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(A1>1,A1<5)

and for C:

AND(A1>5,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.
 
Top