Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentages incorrect
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentages incorrect
On Fri, 20 Jan 2006 17:59:01 -0800, Dandub
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 we 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentages incorrect
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentages incorrect
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect Counting of IF function | Excel Worksheet Functions | |||
Percentages | Excel Worksheet Functions | |||
Incorrect file origin in Excel 2003 | Excel Discussion (Misc queries) | |||
FIX ATTENDANCE CALENDAR TEMPLATE - INCORRECT DATE | Excel Discussion (Misc queries) | |||
Calculating Percentages with Variables | Excel Worksheet Functions |