Hi guys,
It seems like this should be pretty basic, but I've been googling since yesterday with no luck.
A B C
1 10 20 30
2 20 0
3 20 5 25
So, C1=A1+B1. If either column A or B is blank, I would like column C to ignore the formula and return a result of zero as in row 2. Can anyone help?
Bookmarks