Forum Discussion
OR In an IF function
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
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
- Happy to help!
All the best
DamienI need a formula which states: if one or the other are false, then No. if the value in cell1 is greather than 50 or the value of cell #2 is Y, then Y if not, N
but
If the value of cell #2 is Y, then Y no matter what...guh
- Hi Synnovea
If you are able to start a new conversation and attach a sample file, I/the other users here can assist.
Your conditions will be clearer if we can see how you are set up.
Cheers
Damien