Function Correction Help

[Guest]

I have this formula in a cell: =((AG11+AH11)-(X11+Y11))*24*60*60/(AI11-Z11). The result if there is no data is: "#DIV/0!". I would like to have an empty string, 0, or show no value at all if the dependant cells are empty

Is this possible

Thanks,

 

[Dave R.]

You can add

IF(AI11-Z11=0,"",((AG11+AH11)-(X11+Y11))*24*60*60/(AI11-Z11))

(havent tested it). the 24*60*60 thing seems unneccessary, but hey.

I have this formula in a cell:

=((AG11+AH11)-(X11+Y11))*24*60*60/(AI11-Z11). The result if there is no data
is: "#DIV/0!". I would like to have an empty string, 0, or show no value at
all if the dependant cells are empty.