Percentage formula help

[lexkhan]

I need a percentage formula for column C. Also, I need the formula to show 0%, if the column B = 0 but it show error #DIV/0!. I have two column with data Column A and Column B.

Columns A (Number of Cars arrive for Service)
1
4
0
2
3

Columns B (Number of Cars Serviced on-time)
1
0
0
1
2

Thank you in advance.

lex

 

[njimack]

=if(a2*b2,b2/a2,0)

 

[MrKowz]

What formula are you currently using?

I would think you would need

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

 

[VoG]

Try

=IF(A1=0,0,100*B1/A1)

 

[Raychill Canuck]

What I use is =IF(ISERROR(B2/A2),0,(B2/A2)) and format the cells to show as percentage.

There probably is a more elegant solution, but this works for me.

 

[lexkhan]

What I use is =IF(ISERROR(B2/A2),0,(B2/A2)) and format the cells to show as percentage.

There probably is a more elegant solution, but this works for me.

Your formula did the trick.

I would like to thank everyone to helping me out.

lex