How do you use the text command in an if statement ie. if....,tex.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sounds like the cell you are linking to is formatted as Text. Try changing
its format to general.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

referencing text in an IF statement 2
How to do a line break in a text formula 2
comparing text in if statement 1
If any cell in a range is blank question 1
How do you show UDF parameters while typing in formula in Excel? 1
Nested VLOOKUP in IF statement 2
Can an If statement return a formula for false? 1
How do find text with sumproduct if possible 11

Back
Top