You don't get to your final part of the function because you've satisfied
the IF(E13=0,... condition (as an empty cell counts as zero).

If you specifically want to return an empty string if your 4 input cells are
all empty, you can test for that:
=IF(COUNT($B13,$C13,$E13,$G13)=0,"",IF($E130,SUM( G13/(((($E13/2)/0.0393700787)*(($E13/2)/0.0393700787)*3.14159265)*$B13/0.0393700787)),IF($E13=0,SUM(G13/(($B13/0.0393700787)*($C13/0.0393700787)*($D13/0.0393700787))),"")))
--
David Biddulph

"dim" wrote in message
...
Hi all,
I have the following function:
=IF($E130,SUM(G13/(((($E13/2)/0.0393700787)*(($E13/2)/0.0393700787)*3.14159265)*$B13/0.0393700787)),IF($E13=0,SUM(G13/(($B13/0.0393700787)*($C13/0.0393700787)*($D13/0.0393700787))),""))

All works fine when there are values filled into B,C and D13, or B & E13.
Thats great, as intended...but....when there is no value in B13,C13,D13 or
E13, I get the error #DIV/0! in my cell.

Why is the very end part of my function, the ' Otherwise "" ' [,""] not
working?

I need it to just show a blank cell when there are no numbers in B,C,D or
E13?

Any ideas?