Percentage

[Solved/Closed]
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Hello,

Please help!I'm looking at a formula that i have :=IF(OR(I32=0,I33=0,I34=0,I37=0),0,(I34+I33+I32)/(I37+I34+I33+I32)*100)
The formula works fine accept when the values that is divided is the same.(49+2+2)/(49+2+2+0). If the values at the is the same it must show 100 (%) but it does not work then. How can i change it to give me 100. Excel 2007.


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012

TX yes the format did the trick