I have done a spread sheet in which I have one total (D12) divided by another
total (H13)to give a percentage. I formatted the percentage cell to be no
decimals so that it is straight percentage. If I sum the percentage *
another cell, the total figures by using the percentage plus 2 decimals, ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage of 57% X
1548.95 = 882.90. How do I get the later to show the calculated entry of
882.90?
--
Thanks,,
Kim

You seem to be confusing formatting with cell contents. They are not the
same. Excel works with cell contents for calculations. Formatting is for
human comsumption.
Perhaps if you remove all formatting and look at your numbers, you may be
able to determine what is happening. Then apply the formatting to see the
numbers you want.
What are the numbers in your cells?

Tryo

"Kim K" wrote in message
...
I have done a spread sheet in which I have one total (D12) divided by
another
total (H13)to give a percentage. I formatted the percentage cell to be no
decimals so that it is straight percentage. If I sum the percentage *
another cell, the total figures by using the percentage plus 2 decimals,
ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage of 57% X
1548.95 = 882.90. How do I get the later to show the calculated entry of
882.90?
--
Thanks,,
Kim

$2,159/$3,759=57.44%, however the formula that needs to be applied is 57%.

Then 57% * $1,548.98 should equal $882.90, however 57.44 is applied making
the total equal $889.72.

This throws off the rest of the spreadsheet.

The 57% was set to percentage with 0 decimal places.
--
Thanks,,
Kim


"Tyro" wrote:

You seem to be confusing formatting with cell contents. They are not the
same. Excel works with cell contents for calculations. Formatting is for
human comsumption.
Perhaps if you remove all formatting and look at your numbers, you may be
able to determine what is happening. Then apply the formatting to see the
numbers you want.
What are the numbers in your cells?

Tryo

"Kim K" wrote in message
...
I have done a spread sheet in which I have one total (D12) divided by
another
total (H13)to give a percentage. I formatted the percentage cell to be no
decimals so that it is straight percentage. If I sum the percentage *
another cell, the total figures by using the percentage plus 2 decimals,
ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage of 57% X
1548.95 = 882.90. How do I get the later to show the calculated entry of
882.90?
--
Thanks,,
Kim

Kim K --

It seems like you want Excel to calculate the percentage, and apply it to a
number in another cell, no? I think the two numbers in the percentage
calculation were D12 & H13. Let's say the other number ($1548.98) is in cell
A15, and you want the result in A16. The formula in A16 would be:

= (D12/H13)*A15

HTH

"Kim K" wrote:

$2,159/$3,759=57.44%, however the formula that needs to be applied is 57%.

Then 57% * $1,548.98 should equal $882.90, however 57.44 is applied making
the total equal $889.72.

This throws off the rest of the spreadsheet.

The 57% was set to percentage with 0 decimal places.
--
Thanks,,
Kim


"Tyro" wrote:

You seem to be confusing formatting with cell contents. They are not the
same. Excel works with cell contents for calculations. Formatting is for
human comsumption.
Perhaps if you remove all formatting and look at your numbers, you may be
able to determine what is happening. Then apply the formatting to see the
numbers you want.
What are the numbers in your cells?

Tryo

"Kim K" wrote in message
...
I have done a spread sheet in which I have one total (D12) divided by
another
total (H13)to give a percentage. I formatted the percentage cell to be no
decimals so that it is straight percentage. If I sum the percentage *
another cell, the total figures by using the percentage plus 2 decimals,
ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage of 57% X
1548.95 = 882.90. How do I get the later to show the calculated entry of
882.90?
--
Thanks,,
Kim

I simply want excel to calculate the contents of one cell and divide it by
the contents of another number (both dollar amounts) and make it equal the
percentage as 2 digits and no decimals - which it does display as 57% on my
spreadsheet, and is formatted as percentage with 0 decimals.

But when I take that percentage (57%) and multiply it by another cell to get
a new dollar amount ($1,548.95). it should equal 882.90, but it apparently
calculates the percentage as 57.44% therefore making my total 889.65.

I only want the formula to calculate the new dollar amount by using the 57%
and NOT 57.44.
--
Thanks,,
Kim


"pdberger" wrote:

Kim K --

It seems like you want Excel to calculate the percentage, and apply it to a
number in another cell, no? I think the two numbers in the percentage
calculation were D12 & H13. Let's say the other number ($1548.98) is in cell
A15, and you want the result in A16. The formula in A16 would be:

= (D12/H13)*A15

HTH

"Kim K" wrote:

$2,159/$3,759=57.44%, however the formula that needs to be applied is 57%.

Then 57% * $1,548.98 should equal $882.90, however 57.44 is applied making
the total equal $889.72.

This throws off the rest of the spreadsheet.

The 57% was set to percentage with 0 decimal places.
--
Thanks,,
Kim


"Tyro" wrote:

You seem to be confusing formatting with cell contents. They are not the
same. Excel works with cell contents for calculations. Formatting is for
human comsumption.
Perhaps if you remove all formatting and look at your numbers, you may be
able to determine what is happening. Then apply the formatting to see the
numbers you want.
What are the numbers in your cells?

Tryo

"Kim K" wrote in message
...
I have done a spread sheet in which I have one total (D12) divided by
another
total (H13)to give a percentage. I formatted the percentage cell to be no
decimals so that it is straight percentage. If I sum the percentage *
another cell, the total figures by using the percentage plus 2 decimals,
ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage of 57% X
1548.95 = 882.90. How do I get the later to show the calculated entry of
882.90?
--
Thanks,,
Kim

i think this is a rounding function so how do I makje this work?
=ROUND(D12/H13,0) however this returns 100% and not the 57%, so what am I
doing wrong?
--
Thanks,,
Kim


"Kim K" wrote:

I simply want excel to calculate the contents of one cell and divide it by
the contents of another number (both dollar amounts) and make it equal the
percentage as 2 digits and no decimals - which it does display as 57% on my
spreadsheet, and is formatted as percentage with 0 decimals.

But when I take that percentage (57%) and multiply it by another cell to get
a new dollar amount ($1,548.95). it should equal 882.90, but it apparently
calculates the percentage as 57.44% therefore making my total 889.65.

I only want the formula to calculate the new dollar amount by using the 57%
and NOT 57.44.
--
Thanks,,
Kim


"pdberger" wrote:

Kim K --

It seems like you want Excel to calculate the percentage, and apply it to a
number in another cell, no? I think the two numbers in the percentage
calculation were D12 & H13. Let's say the other number ($1548.98) is in cell
A15, and you want the result in A16. The formula in A16 would be:

= (D12/H13)*A15

HTH

"Kim K" wrote:

$2,159/$3,759=57.44%, however the formula that needs to be applied is 57%.

Then 57% * $1,548.98 should equal $882.90, however 57.44 is applied making
the total equal $889.72.

This throws off the rest of the spreadsheet.

The 57% was set to percentage with 0 decimal places.
--
Thanks,,
Kim


"Tyro" wrote:

You seem to be confusing formatting with cell contents. They are not the
same. Excel works with cell contents for calculations. Formatting is for
human comsumption.
Perhaps if you remove all formatting and look at your numbers, you may be
able to determine what is happening. Then apply the formatting to see the
numbers you want.
What are the numbers in your cells?

Tryo

"Kim K" wrote in message
...
I have done a spread sheet in which I have one total (D12) divided by
another
total (H13)to give a percentage. I formatted the percentage cell to be no
decimals so that it is straight percentage. If I sum the percentage *
another cell, the total figures by using the percentage plus 2 decimals,
ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage of 57% X
1548.95 = 882.90. How do I get the later to show the calculated entry of
882.90?
--
Thanks,,
Kim

You need to remember that 57% is 0.57. You have asked it to round to zero
decimal places, so you've rounded it to 1.0, hence the 100%.
If you want to round to the nearest 1%, that is 2 decimal places, so change
your =ROUND(D12/H13,0) to =ROUND(D12/H13,2)
--
David Biddulph

"Kim K" wrote in message
...
i think this is a rounding function so how do I makje this work?
=ROUND(D12/H13,0) however this returns 100% and not the 57%, so what am I
doing wrong?
--
Thanks,,
Kim


"Kim K" wrote:

I simply want excel to calculate the contents of one cell and divide it
by
the contents of another number (both dollar amounts) and make it equal
the
percentage as 2 digits and no decimals - which it does display as 57% on
my
spreadsheet, and is formatted as percentage with 0 decimals.

But when I take that percentage (57%) and multiply it by another cell to
get
a new dollar amount ($1,548.95). it should equal 882.90, but it
apparently
calculates the percentage as 57.44% therefore making my total 889.65.

I only want the formula to calculate the new dollar amount by using the
57%
and NOT 57.44.
--
Thanks,,
Kim


"pdberger" wrote:

Kim K --

It seems like you want Excel to calculate the percentage, and apply it
to a
number in another cell, no? I think the two numbers in the percentage
calculation were D12 & H13. Let's say the other number ($1548.98) is
in cell
A15, and you want the result in A16. The formula in A16 would be:

= (D12/H13)*A15

HTH

"Kim K" wrote:

$2,159/$3,759=57.44%, however the formula that needs to be applied is
57%.

Then 57% * $1,548.98 should equal $882.90, however 57.44 is applied
making
the total equal $889.72.

This throws off the rest of the spreadsheet.

The 57% was set to percentage with 0 decimal places.
--
Thanks,,
Kim


"Tyro" wrote:

You seem to be confusing formatting with cell contents. They are
not the
same. Excel works with cell contents for calculations. Formatting
is for
human comsumption.
Perhaps if you remove all formatting and look at your numbers, you
may be
able to determine what is happening. Then apply the formatting to
see the
numbers you want.
What are the numbers in your cells?

Tryo

"Kim K" wrote in message
...
I have done a spread sheet in which I have one total (D12) divided
by
another
total (H13)to give a percentage. I formatted the percentage cell
to be no
decimals so that it is straight percentage. If I sum the
percentage *
another cell, the total figures by using the percentage plus 2
decimals,
ie
57.44% X 1548.95 = 889.65 however, I want the straight percentage
of 57% X
1548.95 = 882.90. How do I get the later to show the calculated
entry of
882.90?
--
Thanks,,
Kim