Percentage
Solved/Closed
Gouws
Posts
45
Registration date
Sunday 7 February 2010
Status
Member
Last seen
15 April 2012
-
9 Nov 2010 à 07:14
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 12 Nov 2010 à 01:33
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 12 Nov 2010 à 01:33
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
10 Nov 2010 à 04:52
10 Nov 2010 à 04:52
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.
12 Nov 2010 à 01:33