Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

blank cells

ResolvedVersion 2003

Robin has attended:
Excel Advanced course

Blank cells

How can i tell formulas to ignore blank cells and/ or cells that say N/A

RE: blank cells

Hi Robin

Thank you for your question and welcome to the forum.

This would most likely be done by creating a IF function, that tells Excel to use your formula if there is a value greater than 0 in the cell, but to leave the cell blank if there is a blank cell or an N/A error.

If you have a specific example, this would help me to be able to advise further.

Kind regards
Amanda

Fri 28 Nov 2008: Automatically marked as resolved.

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.