Fix Value Statement

[Guest]

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.

 

[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

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.

 

[Guest]

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

Is there a way to display a blank value in a cell when I am doing

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

 

[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???