| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How create blank cell value as the result of Excel "IF" function? | Excel Worksheet Functions | |||
| Finding cell that returns bad "solver_val" function. | Excel Discussion (Misc queries) | |||
| Why MS Excel produce diffrent result for the function "Quartile" | Excel Worksheet Functions | |||
| SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
| Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
Threaded Mode
