| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you use the text command in an if statement ie. if....,tex.
I am trying to enter the following formula in Excel 97 SR2.
=IF(ISNUMBER('1st Half Year'!$K20),IF('1st Half Year'!$K20'1st Half Year'!$J5,TEXT('1st Half Year'!$K20,###),"ND"),"ERROR"). Instead of returning the value of the reference cell as text, the formula returns the entier formula as text. When I remove the Text statement the formula is still displayed. It is only when I use the CTRL Z combination that the formula once again displays the appropriate number, but not as text. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you use the text command in an if statement ie. if....,tex.
Sounds like the cell you are linking to is formatted as Text. Try changing
its format to general. -- Regards, Tom Ogilvy "Ken Biles (PARSONS)" <Ken wrote in message ... I am trying to enter the following formula in Excel 97 SR2. =IF(ISNUMBER('1st Half Year'!$K20),IF('1st Half Year'!$K20'1st Half Year'!$J5,TEXT('1st Half Year'!$K20,###),"ND"),"ERROR"). Instead of returning the value of the reference cell as text, the formula returns the entier formula as text. When I remove the Text statement the formula is still displayed. It is only when I use the CTRL Z combination that the formula once again displays the appropriate number, but not as text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in a command | Excel Discussion (Misc queries) | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| IF COMMAND WITH TEXT | Excel Worksheet Functions | |||
| Hide Row command using if statement | Excel Worksheet Functions | |||
| VBA Command to Look at cell in an If statement | New Users to Excel | |||
Linear Mode
