Percentages

[Guest]

With Excel, can I have one cell give me a percentage of another cell? If so,
can you show me how to do that?

 

[JE McGimpsey]

One way:

A1: <one cell>
B1: <another cell>

C1: =(A1-B1)/B1

or, more efficiently:

C1: =A1/B1-1

Format C1 as a percentage.

 

[Guest]

I would like cell E8 to equal 5 percent of E36, and I would like E11 to equal
15 percent of E36 cna you tell me where I would put the equations and what
the equations would be?

 

[Rob Turnbull]

Hey there,

This will give you the answer you are looking for

(INSERT THE CODE IN INVERTED COMMAS INTO THE CELLS)


E8 =: "=E36*0.05"

E11=: "=E36*0.15"

This will give you the answer you are looking for.

Any other problems just let us know.

Kind regards,

Rob Turnbull
*Sortoutmyexcel.com*

 

[Guest]

Rob,
i'm sorry this is so difficult. i don't understand what you mean when you
say to "insert the code in inverted commas." When I type in E8=:"=E36*0.05"
in the cell E8, it doesn't give me the percentage of the number in cell E36.

 

[JE McGimpsey]

In cell E8, enter

=E36 * 0.05

in cell E11 enter

=E36 * 0.15

The English often call quotation marks "inverted commas", even though in
plain text, quotation marks aren't curved like commas, and with "smart
quotes", only the initial set of "commas" are inverted, and those are
backwards...

 

[Guest]

Thank you very much!

In cell E8, enter

=E36 * 0.05

in cell E11 enter

=E36 * 0.15

The English often call quotation marks "inverted commas", even though in
plain text, quotation marks aren't curved like commas, and with "smart
quotes", only the initial set of "commas" are inverted, and those are
backwards...

 

[gregorio_gomez7]

i designed a workbook i use to calculate the percentage of a fixe
benefit amount to more than 1 beneficiary. i have had problem
controlling the results, for example, 33% of $100.00 produces a result
that when added do not produce an even $100.00. what is the best metho
for resolving this issue? please help me. thank you. :

 

[MrShorty]

Gregorio:

Some may prefer if you start a new thread for your question.

How large of an error are we talking about? Could it just be rounding
error?? Is this the kind of scenario you're looking at?

$100*33%=$33
3*$33=$99<>$100

This is because 33%<>1/3 1/3=33.333333333333333.....%.

Can you be more specific on what your problem is?

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/pennyoff.html


gregorio_gomez7