HI, I am adding a1+b1 together but sometimes one or the other cell is blank and the formula doesn't work. so this is what I was trying.....
if cell b1 is blank then return cell a1 value,or if cell a1 is blank then return cell b1 value, otherwise sum a1+b1
Solved by A. Y. in 12 mins