View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default simple formula help

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!
--
Cheryl