Formula to Categorize a Percentage Range

Dannyh1

Well-known Member

Joined

Nov 18, 2009

Messages

1,144

• Oct 7, 2010

• #2

Hi,

How many scenarios are there? If 7 or less then could use if statement.

If more than 7, could create a lookup table.

 

Upvote 0

C

chuparfaan

Board Regular

Joined

Feb 15, 2009

Messages

59

• Oct 7, 2010

• #3

Hi,

There are 3 Scenarios in total:

100% = A
80-99% = B
0-79% = C

 

Upvote 0

Dannyh1

Well-known Member

Joined

Nov 18, 2009

Messages

1,144

• Oct 7, 2010

• #4

Hi Try

=IF(A1=100%,"A",IF(AND(A1>=80%,A1<100%),"B","C"))

 

Upvote 0

C

chuparfaan

Board Regular

Joined

Feb 15, 2009

Messages

59

• Oct 7, 2010

• #5

It worked - many thanks!

 

Upvote 0

H

hooper12345

New Member

Joined

May 12, 2015

Messages

36

• Mar 23, 2017

• #6

Hello, I'm trying to do something similar but with more criteria.
>= 70% - <100% Maximum
>=50% - <70% Mid-Level
>=40% - <55% Minimum
<40% None

It would be based off the value in cell G38 which is formatted as a percent also. When I tried to duplicate the given answer, excel said I had too many functions.


Thanks a bunch!

 

Last edited: Mar 23, 2017

Upvote 0