View Single Post
  #1   Report Post  
Conditional Formatting
 
Posts: n/a
Default #Value must be 0

I have a time formula.
=IF($AF$4AF7,0,AF7-$AF$4)

Can you help me fina a way when the result is #value it must turn to zero.

Thanks in advance