I am trying to enter a formula within excel that returns a value if two conditions, each in separate cell, are met.
So if the number in cell A1 ends with a 3
And the text in cell A2 is “Remain”
I want cell A3 to say “Yes”.
If neither condition is met i want it to say “no”
And if A1 & A2 are blank, A3 to be blank (rather than #VALUE)
So far I can get a yes or no for the first part using
But I’m having trouble linking in the A2 conditions.