| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PERCENTAGE OF VACANCY
how do I write a formula that finds the percentage of vacancy? 40 apartments
available and 10 are vacant. thank you! -- michelle |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
PERCENTAGE OF VACANCY
How would you do it with a pencil and paper?
-- Don Guillett Microsoft MVP Excel SalesAid Software "michelle wilson" wrote in message ... how do I write a formula that finds the percentage of vacancy? 40 apartments available and 10 are vacant. thank you! -- michelle |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
PERCENTAGE OF VACANCY
Try
=10/40 Format as % Or with those 2 values in A1 & B1 =A1/B1 Mike "michelle wilson" wrote: how do I write a formula that finds the percentage of vacancy? 40 apartments available and 10 are vacant. thank you! -- michelle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| percentage | Excel Worksheet Functions | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| Percentage doesn't add up | Excel Discussion (Misc queries) | |||
Linear Mode
