| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function returns function statement rather than result
Hi. I have a simple "IF" statement in my Excel workbook
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function returns function statement rather than result
You're either entering it in a cell formatted as Text or you're looking at
the formula layer instead of the value layer. If the former, redefine the format of the cell as General (or whatever you want) and re-enter the formula. If the latter, press ctrl/tilde (~) "ckrogers" wrote in message ... Hi. I have a simple "IF" statement in my Excel workbook |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function returns function statement rather than result
Thank you! That fixed it!
"Bob Umlas" wrote: You're either entering it in a cell formatted as Text or you're looking at the formula layer instead of the value layer. If the former, redefine the format of the cell as General (or whatever you want) and re-enter the formula. If the latter, press ctrl/tilde (~) "ckrogers" wrote in message ... Hi. I have a simple "IF" statement in my Excel workbook |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function returns function statement rather than result
Tools Options View uncheck Formulas
"ckrogers" wrote: Hi. I have a simple "IF" statement in my Excel workbook |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2000 - IF function returns wrong result from logical test | Excel Worksheet Functions | |||
| I want result of a function in the cell and not the function itsel | Excel Worksheet Functions | |||
| Function that returns symbols as formula result eg up/down arrow? | Excel Worksheet Functions | |||
| IF Function returns result of formula | Excel Discussion (Misc queries) | |||
| Using Min function with cells in a Row returns incorrect result. | New Users to Excel | |||
Hybrid Mode
