formula assistance

[tanna]

How do I create a formula that figures the percentage of
two number I have 268 subscriptions and 151 of those
ordered additional magazines, I need to figure out the
percentage of those that ordered additional subscriptions
from the total and I'm not familiar with excel formula
creations. Thanks

 

[R.VENKATARAMAN]

for e.g. A1 contains profit 23(whatever currecny). the cost price in B1
is 130 . in C1 type
=A1/B1
and format it as percentage.
that give you profit percentage.
your profit is 17.69%
if you have more entries in A and B then copy C1 to all the other cells In C
column

mine excel 2000
if this is not what you want that means I have not udnerstood your question.

 

[Art]

Use the following formula:
=(A1/A2)
where A1 is Ordered Additional cell and A2 is the Total Subscriptions cell
Change the format of the cell just created to percentage (from the tool
bar/ Format/Cells

Art

 

[Guest]

=151/268
or, if 268 is in A1 and 151 in B1:
=B1/A1

tj