Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Chimera's Song
Lv 6
Chimera's Song asked in Computers & InternetSoftware · 2 weeks ago

I want to create an IF function in Excel - can you help me?

Ok in the field B3 there is some text - if that text contains the word "work" or "furlough" i want it to write the word "employment" into another cell.

SO how do I write it the function?

SOmething like "IF(istext "work", "employment"?  

Is this correct  If not please could you tell me how to write it?

Thanks

2 Answers

Relevance
  • John Alden
    Lv 7
    2 weeks ago

    =IF(OR(A1="WORK",A1="FURLOUGH"),"EMPLOYMENT","")

    Put the formula in the cell you want employment. A1 is the cell where work or furlough could be.

  • David K
    Lv 6
    2 weeks ago

    Put the formula into the 'other cell', not the one with 'work' or 'furlough'.

Still have questions? Get your answers by asking now.