Help With Cell Function
 

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.

Help With Cell Function
 

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" wrote:

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.

Help With Cell Function
 

That's it. Thank you so much.

"Sheeloo" wrote:

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" wrote:

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.

Help With Cell Function
 

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"clralph" wrote:

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.