Percentage
Solved/Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Nov 9, 2010 at 07:14 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Nov 12, 2010 at 01:33 AM
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Nov 12, 2010 at 01:33 AM
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 10, 2010 at 04:52 AM
Nov 10, 2010 at 04:52 AM
is it not a logical trap
you divisor is 49+2+2+0
that means I32=0
your formula condition is if any of these four values is 0 then answer should be 0
i32=0 so the answer is 0
it stops with the first result and does not go to the second result.
whatever you do you will never get 100%
even if yo remove I32=0 form the OR condition that means I32 is not zero the numerator and denominator is not the same and you will not get 100
beside one more thing. you need not multiply by 100. leave it without *100 then you can format the result as percentage.
you divisor is 49+2+2+0
that means I32=0
your formula condition is if any of these four values is 0 then answer should be 0
i32=0 so the answer is 0
it stops with the first result and does not go to the second result.
whatever you do you will never get 100%
even if yo remove I32=0 form the OR condition that means I32 is not zero the numerator and denominator is not the same and you will not get 100
beside one more thing. you need not multiply by 100. leave it without *100 then you can format the result as percentage.
Nov 12, 2010 at 01:33 AM