I want to use an IF statement that looks at the first 4th and 5th character to determine either Outcome A or B.
A1: DTR 09123
09=Outcome A
if not 09=Outcome B
This is not working:
=IF(A1="DTR 09*","Ferry","Live")
I want to use an IF statement that looks at the first 4th and 5th character to determine either Outcome A or B.
A1: DTR 09123
09=Outcome A
if not 09=Outcome B
This is not working:
=IF(A1="DTR 09*","Ferry","Live")
Try:
=IF(LEFT(RIGHT(A1,LEN(A1)-FIND(" ",A1)),2)="09","Ferry","Live")
Is that actually the 5th and 6th caracters? (Spaces count)...
Try
=IF(MID(A1,5,2)="09","Outcome A","Outcome B")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks