What is the result you were hoping for?
If you want a text cell to be ignored, you can accomplish that by
nesting the formula with a logic check to see if the cells are text or
numbers, and ignore the text.
Matthew
On Jun 5, 2008, at 8:03 PM, [EMAIL PROTECTED] wrote:
A very simple but perplexing problem.
A cell adds the values of 3 adjacent cells.
When text is keyed into one of the three cells, the cell adding the
values
shows an error - #value.
Solution?
Thanks,
John.
*************************************************************************
** List info, subscription management, list rules, archives, privacy **
** policy, calmness, a member map, and more at http://www.cguys.org/ **
*************************************************************************
