Hi, sorry for incorrectly titling my last post. I have attached a sample.
Here is what I am trying to do:
I have to classify data into 3 "buckets" based on criteria.
To be a Good: Column B has to be a negative (<0) AND Column C has to be less than 200%
To be Fair: Column B has to be between -4% and +4% AND Column C has to be between 200% and 300%.
To be classified as Poor - all else.
Last edited by analyst1; 09-15-2010 at 03:38 PM. Reason: Improper title
Originally Posted by analyst1
Then you should name this thread propertly too....
- Use concise, accurate thread titles.
- Your post title should describe your problem, not your anticipated solution.
- Use terms appropriate to a Google search.
Give me a sec....I'm working on it
Do you mind if I use If-AND Statements? I'm sure Conditional Formatting would work nicely as well, but I'm not too good with that yet
I would prefer IF/AND.
Let me know if this is what you're looking for
Try this::::
All works, thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks