Thanks this was what I needed. Greg

"CLR" wrote:


=IF(OR(LEFT(A15,1)="H",LEFT(A15,1)="P"),A15,"")

Vaya con Dios,
Chuck, CABGx3


"Greg" wrote:

This is my formula =IF(=OR(Summary!A15<"H*",Summary!A15<"P*"),=Summ ary!A15))

What I want to do is if the cell starts with the Letter H or P than I want
to return that cell as the true statment. If not than nothing. What am I
doing wrong. Somebody please help.