| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
That works too!
"KL" wrote: Hi, Do you really mean the cells [J5] and/or [L5] are empty or do they return a zero-length string as a result of a similar formula, such as =IF(condition,1,""). If the latter is true then try the following formula: =IF(OR(J5="",L5=""),"",L5/J5) Regards, KL "heater" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
