M
ML
Hi.
I'm using this formula
=100*SUM(D11:F11)/SUM(D11:K11)
but if none of the cells in the range have any data, the result is #DIV/0!
I'd like to add to the formula that if nothing is entered to return blank. I
was trying with =IF but I'm getting mixed up with where and what should have
brackets.
Can anyone help.
Thanks
I'm using this formula
=100*SUM(D11:F11)/SUM(D11:K11)
but if none of the cells in the range have any data, the result is #DIV/0!
I'd like to add to the formula that if nothing is entered to return blank. I
was trying with =IF but I'm getting mixed up with where and what should have
brackets.
Can anyone help.
Thanks