LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 146
Default Keeping getting a #Value error

Hello, another day another random problem.

I have just fixed an issue where, I have from someones spreadsheet, two
values.
A
1: 4
2: 4
3: FORMULA

in forumula =SUM(A3-A4)

If A2 is blank then A3 will come up with #VALUE error, unless I go through
and press DELETE key on the blank Cell in A2.

I didn't create this sheet, but is this #Value appearing before I press
delete, because they've used the SUM function to subtract?

Not a huge issue, just curious because I keep having to fix things coming
from a different department and this #Value issue is bugging me because I
don't know why it does this.

Cheers!
 
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
Keeping Rows Together KLG Excel Worksheet Functions 1 September 25th 09 09:10 PM
Keeping last row last PJY Excel Discussion (Misc queries) 3 August 25th 08 09:52 PM
keeping the rows together king_reggie New Users to Excel 10 October 7th 07 04:27 AM
Keeping score The Fool on the Hill Excel Discussion (Misc queries) 3 August 25th 06 09:21 AM
undating new value while keeping the old YJL Excel Discussion (Misc queries) 1 November 14th 05 02:19 AM


All times are GMT +1. The time now is 07:01 AM.

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"