"Value" Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet
that simply totals the cells across the worksheets.

I am getting a "Value" error on the summary worksheet and the fornulas
appear fine. I found however, that if I put a zero in each of the cells that
are current blank (because there was no activity for that item on that
particular day) then the error goes away and I get the total.

Does anyone know what could be causing the problem - I have tried
reformating all of the cells to a numeric setting and it does not help?
 
Sorry, my crystal ball is cloudy. Perhaps we might stand a better chance of
helping you if you were to tell us what formula is giving the "value" error?
 
My guess is that the blank is in fact a space and that you use operators
l;ike +, -, / etc, a space is text and calculate with text will give you
value errorsnote that if you use SUM like

=SUM(A1,A3,A9)

it will ignore text values while

=A1+A3+A9

will throw an error

test one of the balnk cells with

=LEN(A30)

replace A30 with that particular cell, if it doesn't return 0 it has text
values albeit not visible

--


Regards,


Peo Sjoblom
 
Dependent on the error, you might also have an if statement reference to a
sell that is blank, but without a qualifier of what to do if the cell is
blank.

God Bless

Frank Pytel
 
Gee, how about some spell checking!


Peo


Peo Sjoblom said:
My guess is that the blank is in fact a space and that you use operators
l;ike +, -, / etc, a space is text and calculate with text will give you
value errorsnote that if you use SUM like

=SUM(A1,A3,A9)

it will ignore text values while

=A1+A3+A9

will throw an error

test one of the balnk cells with

=LEN(A30)

replace A30 with that particular cell, if it doesn't return 0 it has text
values albeit not visible

--


Regards,


Peo Sjoblom
Click to expand...
 
Back
Top