Percentages incorrect

[Dandub]

Hi, I have a stubburn problem with percentages!! Here are the values
A1 = 179814
B1 = 238920
C1 = sum(A1+B1) = Excel returns 418734
D1 = (A1/C1) = Excel returns 42,94%
E1 = (B1/C1) = Excel returns 57,06%
Now the problem is, when I do the verification, %*418734, Excel does not
return the correct values.
A2 = 42.94%
B2 = 57.06%
C2 = 418734
D2 = (A2*C2) = Excel returns 179804 and not the original 179814
E2 = (B2*C2) = Excel returns 238930 and not the original 238920

Funny enough, there is a rest of 10 when comparing results (D2 was added 10
and E2 is missing 10 to equal their original values.
Please enlighten me... what am I not grasping here?

Thank you

[Ron Rosenfeld]

On Fri, 20 Jan 2006 17:59:01 -0800, Dandub <[email protected]>
wrote:

>Hi, I have a stubburn problem with percentages!! Here are the values
>A1 = 179814
>B1 = 238920
>C1 = sum(A1+B1) = Excel returns 418734
>D1 = (A1/C1) = Excel returns 42,94%
>E1 = (B1/C1) = Excel returns 57,06%
>Now the problem is, when I do the verification, %*418734, Excel does not
>return the correct values.
>A2 = 42.94%
>B2 = 57.06%
>C2 = 418734
>D2 = (A2*C2) = Excel returns 179804 and not the original 179814
>E2 = (B2*C2) = Excel returns 238930 and not the original 238920
>
>Funny enough, there is a rest of 10 when comparing results (D2 was added 10
>and E2 is missing 10 to equal their original values.
>Please enlighten me... what am I not grasping here?
>
>Thank you
>

I presume you entered the 43.94% and the 57.06% manually.

What you are missing is that the values you see in D1 and E1 are NOT the values
that Excel calculated; rather they are the correct values displayed to 2
decimal places.

The values that Excel really returned were:

D1: 42.9422974967402%
E1: 57.0577025032598%

If you put those values into A2 and B2, the verification will work.

More simply, you could enter

A2: =D1
B2: =E1



--ron

[Peo Sjoblom]

It's because you values in D1 and E1 are not 42.94% or 57.06%, you are using
percentage format with 2 decimals meaning you are only displaying these
values, the underlying values are

0.429422974967402 and 0.570577025032598, a better way to do this would be to
use in A2

=D1

and in B2

=E1

now test it

--
Regards,

Peo Sjoblom

Portland, Oregon




"Dandub" <[email protected]> wrote in message
news:[email protected]...
> Hi, I have a stubburn problem with percentages!! Here are the values
> A1 = 179814
> B1 = 238920
> C1 = sum(A1+B1) = Excel returns 418734
> D1 = (A1/C1) = Excel returns 42,94%
> E1 = (B1/C1) = Excel returns 57,06%
> Now the problem is, when I do the verification, %*418734, Excel does not
> return the correct values.
> A2 = 42.94%
> B2 = 57.06%
> C2 = 418734
> D2 = (A2*C2) = Excel returns 179804 and not the original 179814
> E2 = (B2*C2) = Excel returns 238930 and not the original 238920
>
> Funny enough, there is a rest of 10 when comparing results (D2 was added
> 10
> and E2 is missing 10 to equal their original values.
> Please enlighten me... what am I not grasping here?
>
> Thank you
>
>

[Bill Kuunders]

To check back you need to use the same cells that gave you the answer.
I.e. Use D1 and E1 to multiply back not A2 and B2
By punching in 42.94 you ignore the rounding that happened in D1

Have a look at D1 again and format that cell to show 14 decimals to see the
correct answer.
same for E1


--
Greetings from New Zealand
Bill K

"Dandub" <[email protected]> wrote in message
news:[email protected]...
> Hi, I have a stubburn problem with percentages!! Here are the values
> A1 = 179814
> B1 = 238920
> C1 = sum(A1+B1) = Excel returns 418734
> D1 = (A1/C1) = Excel returns 42,94%
> E1 = (B1/C1) = Excel returns 57,06%
> Now the problem is, when I do the verification, %*418734, Excel does not
> return the correct values.
> A2 = 42.94%
> B2 = 57.06%
> C2 = 418734
> D2 = (A2*C2) = Excel returns 179804 and not the original 179814
> E2 = (B2*C2) = Excel returns 238930 and not the original 238920
>
> Funny enough, there is a rest of 10 when comparing results (D2 was added
> 10
> and E2 is missing 10 to equal their original values.
> Please enlighten me... what am I not grasping here?
>
> Thank you
>
>