"IF" function returns function instead of result
Try to format cell as GENERAL instead of TEXT
"ckrogers" wrote:
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
|