Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts

    replace "0" with text

    Formula:
    =(LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F)

    If the value equals "0", I want to replace the "0" with a text "xx" in the cell, that is, show "xx".
    How do I add this to the formula?

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    How about something like this?

    If Lookup value=0 then "xx" else Lookup value

    Code:
    =if((LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F)=0,"xx",(LOOKUP(9E+307,IF(F:F>0,F:F)))-MAX(F:F))
    Last edited by Maudibe; 2014-09-02 at 22:41.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •