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.

=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.

Hi

Here's one way around it:
=IF(OR(LEFT(Summary!A15,1)<"H",LEFT(Summary!A15,1 )<"P"),Summary!A15)

Hope this helps.
Andy.

"Greg" wrote in message
...
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.

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

you had some eraneous "=". Also, the wildcard can't be used in this manner.

"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.

Try it this way.

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

Does that help?


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=517373

All your help is perfect. Except I want one more piece of the puzzle. I
only want the data from A15 if it starts with an H or P. Is there something
needed if it's false.

"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.

All your help is perfect. Except I want one more piece of the puzzle. I
only want the data from A15 if it starts with an H or P. Is there something
needed if it's a false statement. If it's false I want to return it blank.



"Sloth" wrote:

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

you had some eraneous "=". Also, the wildcard can't be used in this manner.

"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.

All your help is perfect. Except I want one more piece of the puzzle. I
only want the data from A15 if it starts with an H or P. Is there something
needed if it's a false statement. If it's false I want to return it blank.


"SteveG" wrote:


Try it this way.

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

Does that help?


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=517373

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.