Formula Will Not Evaluate

[Cecil]

Hello > Sometimes, when I type a simple formula into a cell ( e.g. =IF(A1=A2,"dupe","ok") ), 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 > 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.

[Niek Otten]

The 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

"Cecil" <[email protected]> wrote in message
news:[email protected]...
|
| Hello > Sometimes, when I type a simple formula into a cell ( e.g.
| =IF(A1=A2,"dupe","ok") ), 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 > 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: http://www.excelforum.com/member.php...o&userid=29035
| View this thread: http://www.excelforum.com/showthread...hreadid=535660
|

[Bob Phillips]

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)

"Cecil" <[email protected]> wrote in
message news:[email protected]...
>
> Hello > Sometimes, when I type a simple formula into a cell ( e.g.
> =IF(A1=A2,"dupe","ok") ), 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 > 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:
http://www.excelforum.com/member.php...o&userid=29035
> View this thread: http://www.excelforum.com/showthread...hreadid=535660
>

[Cecil]

Bob, Niek > Your replies give me direction. Thank you for the help. Regards, Cecil.