If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#VALUE! error message help needed please
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 |
#2
|
|||
|
|||
#VALUE! error message help needed please
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 |
#3
|
|||
|
|||
#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 | |
#4
|
|||
|
|||
#VALUE! error message help needed please
The ISTEXT came back false but you gave me an idea. I inserted a row under
the offending one, reentered the data into it and then deleted the offending row and all is now fine. Bob "Niek Otten" wrote in message ... 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 | |
Thread Tools | |
Display Modes | |
|
|