View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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