I have a column of cells using the nper function in them. They refer to cells in their respective rows. The cells referred to are input with numbers as $'s or % with no reference to other cells.
A few of the cells in the column are returning the #NUM! Error, even though the others cells above and below are not. The problem cells are formatted exactly the same as the problem free cells.
I have tried deleting the problem cells and re entering the formulas. I have tried re entering the numbers in the source cells, being sure that the format is the same as the cells above and below. Even tried using the formula in a cell outside of my table referring to the source cells in the problem row. That cell returned the #NUM! Error as well.
Any solutions?
Bookmarks