skip blank rows when pasting formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I incorporate skipping blank cells referenced in this formula when I
do a CTRL + D in a column so the formula only returns a value when referenced
cells have entries and doesn't try to calculate cells with no entries
returning zeros?
=IF(L6=0,0,J6/L6)
 
hi,

control C> Alt+E+Paste Special+Formulas might be the answer to ur
question to copy and paste formulas

if u think this is not helping u, u may please mail me on
(e-mail address removed) with some data

regards,

virendra
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with SUMPRODUCT & converting date to value 1
SumIf across columns instead of rows 2
Help needed 0
circular reference using vlookup 1
Please help! Macros 1
Last "non-blank" value in a Row... 2
returning blank when reference cell is blank 4
To combine various cell formulae in to the final cell 1

Back
Top