| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A "IF" result that will not result in a selected field when using
When using the IF function, is there a result, either "true" or "false that
will not trigger the END key to stop at that specific cell. For example, if I use =IF(A1B2, 2," "), and the statement is false, the cursor will stop on that cell when using the END key because there is a space (" ") in that cell. I have tried using =IF(A1B2, 2,"") and =IF(A1B2,2), but everything produces a result that will stop the cursor on that cell when using the END key. |
| 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 | |||
| How can I find cell contains the result of "maximum" formula | Excel Discussion (Misc queries) | |||
| Why MS Excel produce diffrent result for the function "Quartile" | Excel Worksheet Functions | |||
| how do i enable a drop down list depending on result of "if" funct | Excel Worksheet Functions | |||
| How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions | |||
![A Long[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
