Can't get my IF formula just right
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.
|