simple formula help

C

Cheryl

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
 
W

WKH8919

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
Click to expand...


Try this =IF(OR(I2="",J2=""),"",J2-I2)

Is it work ?

Worawat
 
Top