#VALUE! error message help needed please
One of the values you process in that cell is probably text. I know it looks like a number and is formatted as Number, but still
it is text.
You can easily check with the ISTEXT() function.
Format as Number and re-enter (F2, ENTER)
A frequent cause is that the "number" was copied somewhere else and pasted into the cell.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Bob Newman" wrote in message ...
| Here is an update to the above problem. I have isolated the problem to be
| only in the 1st cell with the error message. If I delete the formula from
| that cell all of the following cells compute fine from that point. Of
| course the total is wrong because it is ignoring everything that came
| previous to that point.
|
| Bob
|
| "Bob Newman" wrote in message
| ...
| I have a very simple checking account SS. All has been working fine. Now
| all of a sudden about halfway down the balance column I get a #VALUE! error
| message in that and all following cells in the column. Too my knowledge
| there has been no change in the formula and all cells that should be are
| formatted for currency. Here's a recap:
| Colum C = Payee, F = Check amount, H=Deposit amount, I=Balance
| The formula in the balance column for row 25 is
| =IF(C25="","",I24-F25+H25). In that way the balance is blank if no check
| has been written in that row. What may cause this? As I say it has been
| working fine.
|
| --
| Thanks in advance... Bob
|
|