Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Will Not Evaluate
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Will Not Evaluate
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" wrote in message ... | | 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 | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Will Not Evaluate
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Will Not Evaluate
Bob, Niek Your replies give me direction. Thank you for the help. Regards, Cecil. -- Cecil ------------------------------------------------------------------------ Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035 View this thread: http://www.excelforum.com/showthread...hreadid=535660 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
how to evaluate the content of a string as if it was a formula | Excel Discussion (Misc queries) |