| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Number range as a percentage
Hi guys, not posted a new thread on here in a while as my excel knowledge develops. However, I'm stumped with a relatively simple idea.
Does anyone know how I can display a range of numbers as a percentage. i.e... Column A Column B 1 200 100% 2 150 75% 3 100 50% 4 50 25% 5 0 0% Column A will be a monetary value in millions - Formatted to an accountancy field. B1 will 100% because A1 is the highest number in the range of A1:A5 Any help greatly appreciated. Jason |
| 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 | |||
Threaded Mode
