Percentages
 

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

One way:

A1: <one cell
B1: <another cell

C1: =(A1-B1)/B1

or, more efficiently:

C1: =A1/B1-1

Format C1 as a percentage.

In article ,
"Vince Carlese" <Vince wrote:

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

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?

"JE McGimpsey" wrote:

One way:

A1: <one cell
B1: <another cell

C1: =(A1-B1)/B1

or, more efficiently:

C1: =A1/B1-1

Format C1 as a percentage.

In article ,
"Vince Carlese" <Vince wrote:

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

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*


--
Rob Turnbull
------------------------------------------------------------------------
Rob Turnbull's Profile: http://www.excelforum.com/member.php...o&userid=24278
View this thread: http://www.excelforum.com/showthread...hreadid=380258

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.

"Rob Turnbull" wrote:


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*


--
Rob Turnbull
------------------------------------------------------------------------
Rob Turnbull's Profile: http://www.excelforum.com/member.php...o&userid=24278
View this thread: http://www.excelforum.com/showthread...hreadid=380258

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...




In article ,
"Vince Carlese" wrote:

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.

"Rob Turnbull" wrote:


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"

Thank you very much!

"JE McGimpsey" wrote:

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...




In article ,
"Vince Carlese" wrote:

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.

"Rob Turnbull" wrote:


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"

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


--
gregorio_gomez7
------------------------------------------------------------------------
gregorio_gomez7's Profile: http://www.excelforum.com/member.php...o&userid=24754
View this thread: http://www.excelforum.com/showthread...hreadid=380258

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?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=380258

Take a look he

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


In article
<gregorio_gomez7.1rejed_1120071914.0822@excelfor um-nospam.com,
gregorio_gomez7
<gregorio_gomez7.1rejed_1120071914.0822@excelfor um-nospam.com wrote:

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