lets say i want to test if the first letter in cell A1 is an "A"
=Mid(A1, 1, 1)="A"
Now lets say i want to find out if either the first and fourth letters in cell A1 is an "A"
I would of thought you could something like this:
=Mid(A1, or(1,4), 1)="A"
Instead of having to do this:
=IF(MID(A1,1,1)="A",TRUE,IF(MID(A!,4,1)="A",TRUE,FALSE))
Am i on the right track?
Could i make the above Formula simpler?
If not, why not?