View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try something like
=IF(N(A1)=0,"",B1/A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"PHM" schrieb im Newsbeitrag
...
My formula result is #DIV/0!
The cells the formula references has no value.
How can I hide the "#DIV/0! ?