percentage question

[Kim K]

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?

 

[Tyro]

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]

$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

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

 

[pdberger]

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

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

 

[Kim K]

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.

 

[Kim K]

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?

 

[David Biddulph]

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)