|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 31st, 2008, 11:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula Not Working
Hi,
When I use the IF formula in excel e.g. =if(h20,"CM","IN) it displays the formula, not result (CM or IN) Anyone knows why? Thanks! 
|
|
#2
July 31st, 2008, 11:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula Not Working
check if the cell is not formated as text.
change it to general. Also maybe is a typo error but your formula needs a "(quote) after IN =if(h20,"CM","IN") hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "novice" escreveu: Hi, When I use the IF formula in excel e.g. =if(h20,"CM","IN) it displays the formula, not result (CM or IN) Anyone knows why? Thanks!
|
|
#3
July 31st, 2008, 11:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula Not Working
Your cell was formatted as text before entering the formula.
Format as general AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "novice" wrote in message ... | Hi, | | When I use the IF formula in excel e.g. =if(h20,"CM","IN) | it displays the formula, not result (CM or IN) | | Anyone knows why? | | Thanks!
|
|
#4
July 31st, 2008, 11:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula Not Working
Sounds like the cell is formatted as TEXT. Change the format to GENERAL.
Then, with the cell still selected press function key F2 then hit ENTER. -- Biff Microsoft Excel MVP "novice" wrote in message ... Hi, When I use the IF formula in excel e.g. =if(h20,"CM","IN) it displays the formula, not result (CM or IN) Anyone knows why? Thanks!
|
|
#5
July 31st, 2008, 11:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula Not Working
And if you see the formula in each cell, maybe you're looking at formulas:
Tools|Options|view tab|Uncheck formulas ctrl-` control-backquote (near the 1/! on my USA keyboard) is the shortcut key novice wrote: Hi, When I use the IF formula in excel e.g. =if(h20,"CM","IN) it displays the formula, not result (CM or IN) Anyone knows why? Thanks! -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
