replace “0” with text

Topic

New Reply

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?

Reply | Quote

Replies

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))

Reply | Quote