"IF" function returns function instead of result
hope you don't put an aporstrophe before the = sign?
like you did in OP: '=IF(K7="LF",L7," ")'
Użytkownik "ckrogers" napisał w
wiadomości ...
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?
"Per Jessen" wrote:
Cindy,
Goto Tools Options Uncheck "Formulas" in the Window options section
OK
Hopes this helps.
---
Per
"ckrogers" skrev i meddelelsen
...
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
|