#1   Report Post  
Old March 7th 08, 05:17 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 2
Default #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.




  #2   Report Post  
Old March 7th 08, 05:36 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 1,091
Default #VALUE

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



"Hank in KC" wrote in message
. ..
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.





  #3   Report Post  
Old March 7th 08, 05:37 AM posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,062
Default #VALUE

are you positive the cells are empty or is there a space character in them?



"Hank in KC" wrote:

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.




  #4   Report Post  
Old March 7th 08, 05:51 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 2
Default #VALUE

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
--
Live simply, love generously


"JMB" wrote in message
...
are you positive the cells are empty or is there a space character in
them?



"Hank in KC" wrote:

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.






  #5   Report Post  
Old March 7th 08, 05:57 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 1,091
Default #VALUE

Blank is equal to 0 in calculations

Tyro

"Hank in KC" wrote in message
. ..
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
--
Live simply, love generously


"JMB" wrote in message
...
are you positive the cells are empty or is there a space character in
them?



"Hank in KC" wrote:

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.










Reply
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



All times are GMT +1. The time now is 11:18 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017