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"