Is the cell that produces the error formatted as text? formatted to treat whatever is typed in the cell as text, and not as a number even if comprised only of ciphers? Check that all cells are formatted either as "general" or as some explicit number format.
At 08:03 PM 6/5/2008, [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. > > > >**************Get trade secrets for amazing burgers. Watch "Cooking with >Tyler Florence" on AOL Food. >(http://food.aol.com/tyler-florence?video=4?&NCID=aolfod00030000000002) > > >************************************************************************* >** List info, subscription management, list rules, archives, privacy ** >** policy, calmness, a member map, and more at http://www.cguys.org/ ** >************************************************************************* ************************************************************************* ** List info, subscription management, list rules, archives, privacy ** ** policy, calmness, a member map, and more at http://www.cguys.org/ ** *************************************************************************
