| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number range as a percentage
Hi Jay,
Am Wed, 10 Apr 2013 15:18:10 +0000 schrieb Jay07: Column A Column B 1 200 100% 2 150 75% 3 100 50% 4 50 25% 5 0 0% in B2: =A2/$A$1 and format as % and copy down Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#2
|
|||
|
|||
|
Quote:
With a small amendment I got it to work in my spread sheet. In B1: =A1/MAX($A$1:$A$5) Shows the highest number as 100%, the lowest as 0% and the rest fall as they may. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add a percentage to a number | Excel Discussion (Misc queries) | |||
| Convert Percentage to number | Excel Programming | |||
| check percentage or whole number | Setting up and Configuration of Excel | |||
| Percentage of a number | Excel Discussion (Misc queries) | |||
| a number as a percentage out of a total | Excel Worksheet Functions | |||
Hybrid Mode
