Help With Cell Function

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

 

[Sheeloo]

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?

 

[clralph]

That's it. Thank you so much.

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?

 

[Shane Devenshire]

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