Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Message | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
#num! error message | Excel Worksheet Functions |