Formula to only use cells with values

[cmeier7]

I am trying to write a formula (in the formula bar) that will only acknowledge cells with values. I have values in some cells and text in others, and have a general formula to encompass all of it. I get a #Value when I have cells in my formula that contain text. How do I "skip over" these cells without deleting them from the formula?

 

[lenze]

You may be able to use the N() Funtion

=N(A1)+N(A2)+N(A3)

It will, however, depend on your formula. N() terurns Text as a 0

lenze

 

[cmeier7]

Thanks, that is exactly what I wanted. Got to remember that.