View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ckrogers ckrogers is offline
external usenet poster
 
Posts: 25
Default "IF" function returns function instead of result

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