Little more help needed for my IF formula
Hi!
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.
=IF(OR(LEFT(Summary!A15,1)="H",LEFT(Summary!A15,1) ="P"),Summary!A15,"")
That's exactly what the formula is doing. It could be shortened a little:
=IF(OR(LEFT(Summary!A15)={"H","P"}),Summary!A15,"" )
Biff
"Greg" wrote in message
...
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.
|