"IF" function returns function instead of result


C

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
 
Ad

Advertisements

P

Per Jessen

Cindy,

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

Hopes this helps.
 
J

Jarek Kujawa

or press CTRL+` to switch/achieve the same


U¿ytkownik "Per Jessen said:
Cindy,

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

Hopes this helps.
 
C

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?
 
C

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
 
T

Teethless mama

Try to format cell as GENERAL instead of TEXT

ckrogers said:
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?
 
Ad

Advertisements

J

Jarek Kujawa

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top