| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do not let a percentage be greater than 100
GOT IT! THANKS!!!!!!!!!!!!!!!!!
JJ Glenn wrote: 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 [quoted text clipped - 9 lines] Thanks! John =MIN(1,150/148) |
| Reply |
| 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 | |||
Hybrid Mode
