Percentage Formulas

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I am trying to calculate a percentage in excel

I am sending out 500 cards and I want to calculate the
percentage of how many cards are mailed back and how many
are faxed back.

What would the formula be.


Thanks
 
=Mailed_back/500

format as percentage will return mailed back cards, do the same for faxed
back

so if you get 200 mailed back

=200/500

gives 0.40 formatted as % returns 40%

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi Tim!

Simply divide the number of cards returned by the number
sent out:

15/500 = .03%
15/500*100 = 3%
A1/B1*100 = 3%

Biff
 
Back
Top