software

Hello gt; Sometimes, when I type a simple formula into a cell ( e.g.
=IF(A1=A2,quot;dupequot;,quot;okquot;) ), the formula does _not_ evaluate when I press
[Enter] or if I move on to another cell. The formula just sits in the
cell, as typed. I do not undertand what the circumstances are that
causes this. One tidbit of info gt; If I Copy and then Paste-Values, the
formula will be replaced with the True or False condition ( dupe or ok
). What am I missing here? Thanks. Cecil.--
Cecil
------------------------------------------------------------------------
Cecil's Profile: www.excelforum.com/member.php...oamp;userid=29035
View this thread: www.excelforum.com/showthread...hreadid=535660The cell you typed the formula in, was formatted as text (at the time you were typing it in). Just formatting to anything else
afterwards doesn't help; Format as General AND re-enter (F2, ENTER)

--
Kind regards,

Niek Otten

quot;Cecilquot; gt; wrote in message
...
|
| Hello gt; Sometimes, when I type a simple formula into a cell ( e.g.
| =IF(A1=A2,quot;dupequot;,quot;okquot;) ), the formula does _not_ evaluate when I press
| [Enter] or if I move on to another cell. The formula just sits in the
| cell, as typed. I do not undertand what the circumstances are that
| causes this. One tidbit of info gt; If I Copy and then Paste-Values, the
| formula will be replaced with the True or False condition ( dupe or ok
| ). What am I missing here? Thanks. Cecil.
|
|
| --
| Cecil
| ------------------------------------------------------------------------
| Cecil's Profile: www.excelforum.com/member.php...oamp;userid=29035
| View this thread: www.excelforum.com/showthread...hreadid=535660
|
Sounds like the cell is formatted as text. Format it as General, then F2 and
Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Cecilquot; gt; wrote in
message ...
gt;
gt; Hello gt; Sometimes, when I type a simple formula into a cell ( e.g.
gt; =IF(A1=A2,quot;dupequot;,quot;okquot;) ), the formula does _not_ evaluate when I press
gt; [Enter] or if I move on to another cell. The formula just sits in the
gt; cell, as typed. I do not undertand what the circumstances are that
gt; causes this. One tidbit of info gt; If I Copy and then Paste-Values, the
gt; formula will be replaced with the True or False condition ( dupe or ok
gt; ). What am I missing here? Thanks. Cecil.
gt;
gt;
gt; --
gt; Cecil
gt; ------------------------------------------------------------------------
gt; Cecil's Profile:
www.excelforum.com/member.php...oamp;userid=29035
gt; View this thread: www.excelforum.com/showthread...hreadid=535660
gt;

Bob, Niek gt; Your replies give me direction. Thank you for the help.
Regards, Cecil.--
Cecil
------------------------------------------------------------------------
Cecil's Profile: www.excelforum.com/member.php...oamp;userid=29035
View this thread: www.excelforum.com/showthread...hreadid=535660