simple formula help

  • Thread starter Thread starter Cheryl
  • Start date Start date
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!
 
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
 
Back
Top