PERCENTAGE OF VACANCY

[michelle wilson]

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

thank you!

 

[Don Guillett]

How would you do it with a pencil and paper?

 

[Mike H]

Try

=10/40

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

=A1/B1

Mike