Feb 01 2018
05:57 PM
- last edited on
Jul 25 2018
10:57 AM
by
TechCommunityAP
Feb 01 2018
05:57 PM
- last edited on
Jul 25 2018
10:57 AM
by
TechCommunityAP
Feb 01 2018 06:38 PM
SolutionHi 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
Mar 14 2018 11:37 AM
I 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
Mar 14 2018 06:35 PM
Feb 01 2018 06:38 PM
SolutionHi 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