|
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. |
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. |
| All times are GMT +1. The time now is 12:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com