View Single Post
  #1   Report Post  
heater
 
Posts: n/a
Default Need a zero value

I need a zero value when J5 and L5 are empty (blank). I keep getting
#VALUE!. I've tried the following formulas:
=IF(J50,L5/J5,IF(J5<0,0))
=IF(J50,L5/J5,0)
=IF(J5=0,"",L5/J5)
All return #VALUE!