blank cells

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Blank cells

Blank cells

resolvedResolved · Medium Priority · Version 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:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips


Server loaded in 0.08 secs.