Convert Ratio to a Percentage

[L40]

I have a formula that I’m using that will return a ratio =IF(N(D11)=0,N(D15)&":0",D15/D11).It works great when I have a number. In this case D11=46 and D15=35 which willreturn 76% ratio if my cell is formatted to percentage or if I use the custom featureand enter 0.0”:1” then it will return 0.8:1. My issue is when I have a “0” inD11 I need it to return 100%.<o></o>

 

[DushiPunda]

With the cell formatted as a percentage:

=IF(D11=0,1,D15/D11)

 

[L40]

Thank you so much. That seemed to do the trick