Solved Excel Formula - Greater Than and Less Than

July 13, 2016 at 03:07:40
Specs: Windows 7
Hi There,

I'm trying to work out an excel formula that will show me a number based upon information from another worksheet in the same book.

Basically, I have 14 people who through other formulas each have an average rating, but for my front cover of the work book, I want to show the following information;

Percentage of TL's ranked 2 or less
Percentage of TL's ranked 3
Percentage of TL's ranked 4 or more

I can't seem to figure out what formula I need though to show me this information.

I've tried;

=SUM(Sheet18!E5:E18,"<2")
=SUM(Sheet18!E5:E18)<2

=IF(Sheet18!E5:E18,"<2")
=IF(Sheet18!E5:E18)<2

=SUM(Sheet18!E5:E18/14)

however once all my source information is generated, it won't show me a number that gives me an indication of how many out of 14 are ranked <2, 3, 4> as a percentage.

Any help would be greatly appreciated.

Many thanks


See More: Excel Formula - Greater Than and Less Than

Report •


#1
Report •

#2
July 13, 2016 at 05:45:48
✔ Best Answer
There is also the =RANK() function.

With your data like:

       A            B
1)  Values  Rank High to Low
2)    7            4           
3)    4            5           
4)    25           1           
5)    8            3           
6)    16           2           

In cell B2 enter the formula: =RANK(A2,$A$2:$A$6)
then drag down and you get the above.
You can then simply sort on the rank column.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Related Solutions


Ask Question