IF formula with multiple conditions

[peanaboo]

I have a spreadsheet where column D contains a 4-8 character code.

AAISDJ
KDFJS
PSDFS
PDDSP
PASF

If the first character is P and the fourth is F I need "Verify" to be put in column H

AAISDJ
KDFJS
PSDFS Verify
PDDSP
PASF Verify

Is this something that can be accomplished?

 

[T. Valko]

I have a spreadsheet where column D contains a 4-8 character code.

AAISDJ
KDFJS
PSDFS
PDDSP
PASF

If the first character is P and the fourth is F I need "Verify" to be put in column H

AAISDJ
KDFJS
PSDFS Verify
PDDSP
PASF Verify

Is this something that can be accomplished?

Try this...

Book1
	D	H
2	AAISDJ
3	KDFJS
4	PSDFS	Verify
5	PDDSP
6	PASF	Verify
Sheet1

Formula entered in H2 and copied down:

=IF(AND(LEFT(D2)="P",MID(D2,4,1)="F"),"Verify","")

 

[VoG]

Try

=IF(AND(LEFT(D1,1)="P",MID(H1,4,1)="F"),"Verify","")

 

[peanaboo]

THANK YOU! It worked perfectly.