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