Thread: I want to copy a formula n Excel but skip any blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ann
 
Posts: n/a
Default I want to copy a formula n Excel but skip any blank cells
I'm trying to copy(downward) a formula but I want it to leave blank cells
blank. It's gining it a value of 0 currently. Here's the formula I want
copied skipping blank cells.
=IF(+E8=0,0,+F8/E8)
Reply With QuoteReply With Quote