Maths % how do you show when 0

[Sahil123]

Hi all

If I’m trying to find out a percentage of a total where number of people to start were 0 - how do u show it

for example

An agent was assigned 2 tasks but he completed 4 would be 4/2 = 200%

An Agent was assigned 2 tasks but he completed 1 would be 1/2 = 50%

what if the agent was assigned 0 tasks but he completed 4 tasks - how would you calculate or show this as I can’t do 4/0


Thank you

 

[iliace]

I would probably show 100% - mathematically incorrect, but technically the agent did complete 100% of his zero tasks, regardless of how many they actually completed. If that doesn't sit right with you, consider going with "n/a", or "-", or something else to indicate that the calculation does not apply/doesn't make sense.

 

[Rick Rothstein]

I presume your percentages are generated by a formula... if so, I would test if the denominator cell's value is 0 and display the empty text string ("") if it is, otherwise display your calculated percentage. So, if your formula is this...

=A1/B1

then I would change it to this...

=IF(B1=0,"",A1/B1)

 

[Sahil123]

Thank u Rick