simplifying a =Mid() equation
Posted
by
JT.
on Stack Overflow
See other posts from Stack Overflow
or by JT.
Published on 2012-07-06T02:55:16Z
Indexed on
2012/07/06
3:15 UTC
Read the original article
Hit count: 80
excel
|excel-formula
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?
© Stack Overflow or respective owner
