=IF(COUNTIF(H45:H46,FALSE)>=1,"",E46/E45*24)
I have a formula that is giving me a #DIV/0!. Which I know is because column E is 0. But, I need this formula return blank instead of #DIV/0. How can I rewrite this formula to return a blank if it is 0?
A B C D E F G H
R45 mb76A_FIMS-12 01-Jan-14 00:00:00 mb76A_FI4500-2/A-PV Sanned 0 NA NA True
Bookmarks