Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am doing a simple percentage calculation, however the two percentages are
not adding up to 100%, is there a reason for this? Thanks for any help with this matter. |
#2
![]() |
|||
|
|||
![]()
Could you provide an example?
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
#3
![]() |
|||
|
|||
![]()
What are your input values?
"tifosi3" wrote: I am doing a simple percentage calculation, however the two percentages are not adding up to 100%, is there a reason for this? Thanks for any help with this matter. |
#4
![]() |
|||
|
|||
![]()
We'd need to have the exact numbers you're working with.
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "tifosi3" wrote in message ... I am doing a simple percentage calculation, however the two percentages are not adding up to 100%, is there a reason for this? Thanks for any help with this matter. |
#5
![]() |
|||
|
|||
![]()
The values a
119/128 and 8/128 The formulas are F21/B21 and D21/B21 The return values are 93% and 6% Thanks "bj" wrote: What are your input values? "tifosi3" wrote: I am doing a simple percentage calculation, however the two percentages are not adding up to 100%, is there a reason for this? Thanks for any help with this matter. |
#6
![]() |
|||
|
|||
![]()
119 + 8 does not equal 128. Hence they do not add up to 100%.
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
#7
![]() |
|||
|
|||
![]()
Thanks, that was embarrassing
"VoG via OfficeKB.com" wrote: 119 + 8 does not equal 128. Hence they do not add up to 100%. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
#8
![]() |
|||
|
|||
![]()
I wish I could say I have never done the same thning, but I can't
"tifosi3" wrote: Thanks, that was embarrassing "VoG via OfficeKB.com" wrote: 119 + 8 does not equal 128. Hence they do not add up to 100%. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Percentages in a Range | Excel Worksheet Functions | |||
Calculating Percentages in a Range | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Calculating Percentages with Variables | Excel Worksheet Functions | |||
Calculating percentages | Excel Worksheet Functions |