Thread: How do you use the text command in an if statement ie. if....,tex.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Biles(PARSONS) Ken Biles(PARSONS) is offline
external usenet poster
  
Posts: 1
Default 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.


Reply With QuoteReply With Quote