Hi,

When I use the IF formula in excel e.g. =if(h2<0,"CM","IN)
it displays the formula, not result (CM or IN)

Anyone knows why?

Thanks!

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(h2<0,"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(h2<0,"CM","IN)
it displays the formula, not result (CM or IN)

Anyone knows why?

Thanks!

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(h2<0,"CM","IN)
| it displays the formula, not result (CM or IN)
|
| Anyone knows why?
|
| Thanks!

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(h2<0,"CM","IN)
it displays the formula, not result (CM or IN)

Anyone knows why?

Thanks!

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(h2<0,"CM","IN)
it displays the formula, not result (CM or IN)

Anyone knows why?

Thanks!

--

Dave Peterson