LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Message Mark Excel Discussion (Misc queries) 0 September 29th 06 06:09 PM
VBA Error Message "Compile Error...." Steve Excel Discussion (Misc queries) 3 July 15th 05 09:20 AM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 21st 05 11:39 PM
#num! error message Brenda Excel Worksheet Functions 4 November 19th 04 03:55 AM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"