Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Percentages

0 views
Skip to first unread message

GENO

unread,
Nov 23, 2009, 4:16:01 AM11/23/09
to
Hi

I would like to use a scoring method in percentages which would recognise 1
to 5 as 0% - 100%. e.g 1= 0-24%, 2= 25-49%, 3= 50-74%, 4= 75-99% and 5= 100%,
thanking you in advance,

Geno...

etaf

unread,
Nov 23, 2009, 6:36:09 AM11/23/09
to

can you be more specific ....

However, assuming that you want to put the Value 1 to 5 in a cell where
another cell is grouped as percentages

try (I have assumed the cell is formated as %, hence decimal values)
=IF(D9=1,5,IF(D9>=0.75,4,IF(D9>=0.5,3,IF(D9>=0.25,2,1))))


--
etaf
------------------------------------------------------------------------
etaf's Profile: http://www.thecodecage.com/forumz/member.php?userid=1223
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=156432

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

Gord Dibben

unread,
Nov 23, 2009, 12:05:26 PM11/23/09
to
=LOOKUP(B1,{1,2,3,4,5},{0.24,0.49,0.74,99,1})*A1 entered in C1

Where A1 contains value, B1 contains 1 through 5


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 01:16:01 -0800, GENO <GE...@discussions.microsoft.com>
wrote:

0 new messages