|Calculating fractions and or percentages
|Page 1 of 1|
|Author:||olle [ Fri Aug 31, 2007 6:33 am ]|
|Post subject:||Calculating fractions and or percentages|
I have a sheet in which allot of percentages are used. I constantly got the result #value! when I requested the formulaResultValue. I played with changing the decimal sepperator from , to . on my system, I switched from percentage to numbers so that 12% would be represented as 0.12 but nothing works. I then made a smaller test case as follow for which I get #N/A!. Any ideas?
|Author:||claudiu [ Mon Sep 03, 2007 6:19 am ]|
I reproduced your test (fixing the errors) and I came up with this which worked just fine. My default systems settings for decimal separator is . (dot)
Please, try it and let me know if this worked for you. If not, send the file you are working with to firstname.lastname@example.org (remove the confidential content) and I will have a look at it.
|Page 1 of 1||All times are UTC - 4 hours|
|Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group