Forum Discussion
#Value error on a simple formula
I have two columns of numbers. (Debits & credits). I need to net these columns using a simple x-y formula. For every row one cell has a positive number and cell that is blank. I have one workbook tha...
In calculations blank cell is considered as one having zero value, other words returns 0. Perhaps you have not blank cells, but cells with empty string, when you have an error. Usually formulas return empty string instead of blank, like =IF(A1>B1, A1*10, "")
As workaround instead of
=A1+B1
you may use
=SUM(A1:B1) or =SUM(A1,B1)
SUM() ignores all texts.