Forum Discussion

Judy Tran's avatar
Judy Tran
Copper Contributor
Feb 02, 2018
Solved

OR In an IF function

Hi,

I have two columns containing serial numbers.

I need a function which states that if the first column ends in either 616 or 796, take that column’s serial number and if it ends in neither, take the second column’s serial number.

Is there a function I can use to do this?
excel
Formulas & Functions
  • Damien_Rosario's avatar
    Damien_Rosario
    Feb 02, 2018

    Hi Judy

     

    You'll need a formula to do what you are proposing.

     

    I've drafted this formula, see if it does the job for you?

     

    =IF(OR(RIGHT(A2,3)="616",RIGHT(A2,3)="796"),A2,B2)

     

    A2 represents the first value in your First column.

    B2 represents the second value in your Second column.

     

    Replace the cell references with your desired ones.

     

    I've also attached a same of the worksheet I've made for you to see it in action.

     

    Let me know if this did the trick?

     

    Cheers

    Damien

5 Replies

Sort By
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Feb 02, 2018

    Hi Judy

     

    You'll need a formula to do what you are proposing.

     

    I've drafted this formula, see if it does the job for you?

     

    =IF(OR(RIGHT(A2,3)="616",RIGHT(A2,3)="796"),A2,B2)

     

    A2 represents the first value in your First column.

    B2 represents the second value in your Second column.

     

    Replace the cell references with your desired ones.

     

    I've also attached a same of the worksheet I've made for you to see it in action.

     

    Let me know if this did the trick?

     

    Cheers

    Damien

Resources