Thread
:
Need a zero value
View Single Post
#
1
heater
Posts: n/a
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!
Reply With Quote