Function Correction Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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.




Syd said:
I have this formula in a cell:
Click to expand...
=((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.
 
Back
Top