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...
samd685 ,,,
The #VALUE! error is a common issue, and possible reasons are,,,
- Value is other than expected type.
- Cells is/are left blank.
- Formula encounters with literally a text value.
- Dates are evaluated as text by Excel.
Fixing needs entering the right kind of value.
Below I've shown a sample data finding how to calculate RUNNING TOTAL while handling Debit & Credit amount.
N.B.
Formula In cell E81 =(B81+D80)-C81 , encounters with #VALUE error in Cell E84, reason is that the cell C84 has TEXT value .
Now to trap the error I've used correct formula in cell D81 is,,
=IFERROR(B81+D80-C81,D80)