Forum Discussion

Eqa33's avatar
Eqa33
Brass Contributor
Jan 03, 2022
Solved

Extend ISNUMBER Search

Hi,   I have a Table of data one of the columns automatically inserts an option depending on the results in an earlier column. what I'm wanting to do is is look at 2 columns of info and depending o...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jan 03, 2022

    Eqa33 That could be:

    =IF(F5="USA","EXP",IF(L5="","",IF(ISNUMBER(SEARCH("dr",L5)),"FRE","GST")))

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 03, 2022

Eqa33 That could be:

=IF(F5="USA","EXP",IF(L5="","",IF(ISNUMBER(SEARCH("dr",L5)),"FRE","GST")))

 

  • Eqa33's avatar
    Eqa33
    Brass Contributor
    Jan 04, 2022
    That's great. Thanks very much. I actually needed it to say, if it doesn't equal USA then EXP, which I have fixed, but now even a blank cell is registering as EXP. what do I need to do to get it to ignore blank cells?
    Thanks again.
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 04, 2022

      Eqa33 

      =IF(AND(F5<>"USA",F5<>""),"EXP",IF(L5="","",IF(ISNUMBER(SEARCH("dr",L5)),"FRE","GST")))

       

      • Eqa33's avatar
        Eqa33
        Brass Contributor
        Jan 04, 2022
        Fantastic. Thanks very much.

        One more question if you don't mind?

        I'm trying to conditional format cells that respond to the word refund in say column C. I want the the value in column F to turn into a negative currency number. How do I do that.

        Thanks very much again.

        Eqa

Resources