"IF" function returns function instead of result

[ckrogers]

Hi. I have a simple '=IF(K7="LF",L7," ")' function in my workbook to display
the value in cell L7 if the Logical Test is "TRUE", otherwise leave the cell
blank. When I'm building the function and insert the arguments, it shows me
the correct result ... but when I hit "OK" to insert the function, it
displays the actual function rather than the result. Why?
Thanks for any help.
Cindy

 

[Per Jessen]

Cindy,

Goto Tools > Options > Uncheck "Formulas" in the Window options section > OK

Hopes this helps.

 

[Jarek Kujawa]

or press CTRL+` to switch/achieve the same

Cindy,

Goto Tools > Options > Uncheck "Formulas" in the Window options section >
OK

Hopes this helps.

 

[ckrogers]

Unfortunately, that box isn't checked ... and I have many other formulas in
my workbook that are working correctly. Any other suggestions? Is it
possible I have TOO MANY formulas in the workbook?

 

[ckrogers]

Someone else suggested that my cell was formatted as Text and should be
General. I changed it as suggested and that fixed my problem.

Thank you all!
Cindy

 

[Teethless mama]

Try to format cell as GENERAL instead of TEXT

Unfortunately, that box isn't checked ... and I have many other formulas in
my workbook that are working correctly. Any other suggestions? Is it
possible I have TOO MANY formulas in the workbook?

 

[Jarek Kujawa]

hope you don't put an aporstrophe before the = sign?

like you did in OP: '=IF(K7="LF",L7," ")'