I can’t seem to work out the formula for calculating a ratio using the data in the pivot table.

I’ve added a column next to the pivot table to work out the ratio between to columns.

=SUM(B11/C11)

But what if there is no data in cell (B11), I want to return a “ “ (blank space)… but it returns a #DIV/0!

Can anyone help… attached is the excel worksheet im working on

= If(and(b11<>"",c11<>""),(b11/ C11),"")

I confused. Wouldn't #Div/0 error indicate that C11 is zero?