Dear Excel experts,
How can I make the outcome of a formula (eg. =A1*A2) result in a blank cell
if either Cell A1 or Cell A2 is blank (no data typed in the cell)?
If either Cell A1 or A2 is actually zero it should not result in a blank Cell.
I need to define the outcome of the folrmula as blank, because I want to
take the average of a range of rhese formulas. If some data have not been
entered, they should be ignored in the average and not counted as 0.
Hope you can give me a clue,
Jan Bart
Bookmarks