| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do not let a percentage be greater than 100
I am calculating percentages, to come up with the percentage, in some cells I
am taking a larger number and dividing by a smaller number, therefore ending up with a percentage greater than 100. E.g. 150/148 = 101.35% How can I format my percentage cells so any percentage that is GREATER than 100 ONLY DISPLAYS as 100? Is there a way to do that??? Thanks! John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| greater than.. | Excel Discussion (Misc queries) | |||
| Adding a figure + a percentage after using lesser than or greater | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| Greater then/less then | Excel Worksheet Functions | |||
Threaded Mode
