Help With Cell Function

  • Thread starter Thread starter clralph
  • Start date Start date
C

clralph

I have a form that is filled out by our salesmen. I cannot remember what to
use when they type in one cell for it to show up in another cell. The CELL
and SUM do not work. I get Circular errors.

Thank you for the help.
 
If you want the value in cell A1 to show up in B1 type this
=A1
in B1.

Is that what you wanted or did I totally misunderstand?
 
That's it. Thank you so much.

Sheeloo said:
If you want the value in cell A1 to show up in B1 type this
=A1
in B1.

Is that what you wanted or did I totally misunderstand?
Click to expand...
 
Hi,

You could use both the CELL and the SUM function, but I can't imagine why?

=CELL("contents",A1)
=SUM(A1)

but really, as Sheeloo suggested
=A1
 
Back
Top