I want to copy a formula n Excel but skip any blank cells

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

Guest

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)
 
Try =IF(ISBLANK(E8),"",IF(E8=0,0,F9/E8))
or =IF(E8="","",IF(E8=0,0,E9/F8))
This is called 'nesting' of IFs
best wishes
 
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

AVG or Return 1 value from either of 2 cells if one is blank 8
Cell Referencing 5
Using ISNA function, but replace the blank cell with text 3
Payment calculation 1
Copy Data from Within same Workbook 1
Count everything in a Column "except" 2
Time Sum in Excel 1
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top