Forum Discussion

Wendy Reynolds's avatar
Wendy Reynolds
Copper Contributor
May 08, 2018

IF function query

I am trying to enter a formula which I think should be an IF function.  I can get it to work with just one logical test value but need to add 2 others.  If text entered in E column cell = UFN or CP or IP I want a value of n/a returned in the corresponding cell in G column.  Can anyone help?  I am using Microsoft Excel 2010.

Formulas & Functions
Need Help

2 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 08, 2018

    Hi Wendy,

     

    In this case, you have an option to embed the OR function inside the IF function as follows:

    =IF(OR(E1="UFN",E1="CP",E1="IP"),"n/a","")

     

    I hope this helps you

    Regards

    • Wendy Reynolds's avatar
      Wendy Reynolds
      Copper Contributor
      May 08, 2018

      Thanks Haytham, I thought there needed to be an OR in the formula but wasn't sure where to put it.  I will try this.  Thanks again.

Resources