PERCENTAGE OF VACANCY

  • Thread starter Thread starter michelle wilson
  • Start date Start date
M

michelle wilson

how do I write a formula that finds the percentage of vacancy? 40 apartments
available and 10 are vacant.

thank you!
 
Try

=10/40

Format as %
Or with those 2 values in A1 & B1

=A1/B1

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate and IF? 2
Query Question 1
HELP: Averaging values if they meet certain criteria 3
Percentage displays wrong 3
Excel base year add up escalation problem.... 1
Change wording after date passes 4
columns in calendar 2
COUNTING 3

Back
Top