 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008#VALUE
I have a simple spreadsheet in which three columns are used to keep track of an account balance. Column A is withdrawals, B is deposits, C is balance. A typical entry in C25 would be =C24 - A25 + B25. One of the cells in A or B will be empty in row 25. This approach has been working well and blank cells have resulted in a value of zero being used in the calculations. However, recently the #VALUE result comes up instead of the expected result.. If I replace the empty cell with 0 then the formula appears to work correctly, so the problem is related to how the lack of an entry in one of the cells is being considered. The confusing thing is that entering a value of zero has not been required previously. All three columns have been formatted as number. Formatting means presenting the cell value in a certain way for human consumption. The #VALUE error means the cell content is not appropriate for the purpose that you are using. For example if A1 = ab and A2 = 1 and A3 is =A1+A2, then #VALUE occurs because A1 is not numeric. Tyro >I have a simple spreadsheet in which three columns are used to keep track >of an account balance. [quoted text clipped - 13 lines] > > All three columns have been formatted as number. are you positive the cells are empty or is there a space character in them? > I have a simple spreadsheet in which three columns are used to keep track of > an account balance. [quoted text clipped - 13 lines] > > All three columns have been formatted as number. Good question. I went to the empty cells and used EDIT-CLEAR-ALL and the result was good in that a correct result was obtained without having to put a zero value in the empty cell. Hopefully this solves my problem as well as explains it. Many grateful thanks! Hank  SignatureLive simply, love generously > are you positive the cells are empty or is there a space character in > them? [quoted text clipped - 23 lines] >> >> All three columns have been formatted as number. Blank is equal to 0 in calculations Tyro > Good question. I went to the empty cells and used EDIT-CLEAR-ALL and the > result was good in that a correct result was obtained without having to [quoted text clipped - 32 lines] >>> >>> All three columns have been formatted as number.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.