Add a number based on list of criteria ???
 

Example: Cell A = 50, Cell B = 96%, Cell C = Cell A + (Cell A x Cell
B) = 98

I want to be able to compare the list of criteria and add a number to
Cell C accordingly
For example: If Cell B is between 95 and 100%, Add 1 to the total in
Cell C
If between 85 and 94%, add 2... etc.

There are more than 7 so I know I can't simply nest If statements...
Any advice on how I could fairly simply accomplish this?

TIA!

Add a number based on list of criteria ???
 

See one answer in microsoft.public.excel

Please don't post the same message to different groups. It tends to
fragment your answers, and potentially wastes the time of those replying
to posts that already have been answered.


For tips on using these newsgroups effectively, see

http://cpearson.com/excel/newposte.htm


In article ,
(Michelle) wrote:

Example: Cell A = 50, Cell B = 96%, Cell C = Cell A + (Cell A x Cell
B) = 98

I want to be able to compare the list of criteria and add a number to
Cell C accordingly
For example: If Cell B is between 95 and 100%, Add 1 to the total in
Cell C
If between 85 and 94%, add 2... etc.

There are more than 7 so I know I can't simply nest If statements...
Any advice on how I could fairly simply accomplish this?

TIA!