Fix Value Statement

S

sihlen

Is there a way to display a blank value in a cell when I am doing a calculation in that cell and one of the cells in the calculation is blank? For example, F10+30 is in cell J10. F10 is blank. I get a "#value!" because there is nothing in F10, which would be a date if a certain condition is met.
 
P

Peo Sjoblom

I don't believe there is nothing in F10, maybe it is a "" or a " " ,
otherwise you would not get an error, however
you can use the sum function which disregards text strings whether they are
words or blanks

=SUM(F10,30)

--

Regards,

Peo Sjoblom


sihlen said:
Is there a way to display a blank value in a cell when I am doing a
Click to expand...
calculation in that cell and one of the cells in the calculation is blank?
For example, F10+30 is in cell J10. F10 is blank. I get a "#value!" because
there is nothing in F10, which would be a date if a certain condition is
met.
 
S

sihlen

Thanks for the quick response. You were right in that there must have been a space in the cell. Do you know how I can get the value in the next cell to now display as blank? Thanks in advance

----- Peo Sjoblom wrote: ----

I don't believe there is nothing in F10, maybe it is a "" or a " "
otherwise you would not get an error, howeve
you can use the sum function which disregards text strings whether they ar
words or blank

=SUM(F10,30

--

Regards

Peo Sjoblo


sihlen said:
Is there a way to display a blank value in a cell when I am doing
Click to expand...
calculation in that cell and one of the cells in the calculation is blank
For example, F10+30 is in cell J10. F10 is blank. I get a "#value!" becaus
there is nothing in F10, which would be a date if a certain condition i
met
 
D

Dave Peterson

=if(F10="","",sum(f10,30))
or if you really have spaces in F10:

=if(trim(f10)="","",sum(f10,30))

And if you're validating first, maybe just f10+30 instead of the =sum()
function???
 
Top