software

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.
quot;Slothquot; wrote:

gt; =IF(OR(LEFT(Summary!A15,1)=quot;Hquot;,LEFT(Summary!A15,1) =quot;Pquot;),Summary!A15,quot;quot;)
gt;
gt; you had some eraneous quot;=quot;. Also, the wildcard can't be used in this manner.
gt;
gt; quot;Gregquot; wrote:
gt;
gt; gt; This is my formula =IF(=OR(Summary!A15lt;gt;quot;H*quot;,Summary!A15lt;gt;quot;P*quot;),=Summ ary!A15))
gt; gt;
gt; gt; What I want to do is if the cell starts with the Letter H or P than I want
gt; gt; to return that cell as the true statment. If not than nothing. What am I
gt; gt; doing wrong. Somebody please help.Hi!

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

gt;gt; =IF(OR(LEFT(Summary!A15,1)=quot;Hquot;,LEFT(Summary!A15,1) =quot;Pquot;),Summary!A15,quot;quot;)

That's exactly what the formula is doing. It could be shortened a little:

=IF(OR(LEFT(Summary!A15)={quot;Hquot;,quot;Pquot;}),Summary!A15,quot;quot; )

Biff

quot;Gregquot; gt; wrote in message
...
gt; All your help is perfect. Except I want one more piece of the puzzle. I
gt; only want the data from A15 if it starts with an H or P. Is there
gt; something
gt; needed if it's a false statement. If it's false I want to return it
gt; blank.
gt;
gt;
gt;
gt; quot;Slothquot; wrote:
gt;
gt;gt; =IF(OR(LEFT(Summary!A15,1)=quot;Hquot;,LEFT(Summary!A15,1) =quot;Pquot;),Summary!A15,quot;quot;)
gt;gt;
gt;gt; you had some eraneous quot;=quot;. Also, the wildcard can't be used in this
gt;gt; manner.
gt;gt;
gt;gt; quot;Gregquot; wrote:
gt;gt;
gt;gt; gt; This is my formula
gt;gt; gt; =IF(=OR(Summary!A15lt;gt;quot;H*quot;,Summary!A15lt;gt;quot;P*quot;),=Summ ary!A15))
gt;gt; gt;
gt;gt; gt; What I want to do is if the cell starts with the Letter H or P than I
gt;gt; gt; want
gt;gt; gt; to return that cell as the true statment. If not than nothing. What
gt;gt; gt; am I
gt;gt; gt; doing wrong. Somebody please help.
gt;
The FALSE condition is already in place to return a blank. That is the
double quotes quot;quot; at the end. Is it not working?

quot;Gregquot; wrote:

gt; All your help is perfect. Except I want one more piece of the puzzle. I
gt; only want the data from A15 if it starts with an H or P. Is there something
gt; needed if it's a false statement. If it's false I want to return it blank.
gt;
gt;
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; =IF(OR(LEFT(Summary!A15,1)=quot;Hquot;,LEFT(Summary!A15,1) =quot;Pquot;),Summary!A15,quot;quot;)
gt; gt;
gt; gt; you had some eraneous quot;=quot;. Also, the wildcard can't be used in this manner.
gt; gt;
gt; gt; quot;Gregquot; wrote:
gt; gt;
gt; gt; gt; This is my formula =IF(=OR(Summary!A15lt;gt;quot;H*quot;,Summary!A15lt;gt;quot;P*quot;),=Summ ary!A15))
gt; gt; gt;
gt; gt; gt; What I want to do is if the cell starts with the Letter H or P than I want
gt; gt; gt; to return that cell as the true statment. If not than nothing. What am I
gt; gt; gt; doing wrong. Somebody please help.
gt;

=IF(OR(LEFT(SUMMARY!A15,1)=quot;Hquot;,LEFT(SUMMARY!A15,1) =quot;Pquot;),SUMMARY!A15,quot;quot;)Vaya con Dios,
Chuck, CABGx3
quot;Gregquot; wrote:

gt; All your help is perfect. Except I want one more piece of the puzzle. I
gt; only want the data from A15 if it starts with an H or P. Is there something
gt; needed if it's a false statement. If it's false I want to return it blank.
gt;
gt;
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; =IF(OR(LEFT(Summary!A15,1)=quot;Hquot;,LEFT(Summary!A15,1) =quot;Pquot;),Summary!A15,quot;quot;)
gt; gt;
gt; gt; you had some eraneous quot;=quot;. Also, the wildcard can't be used in this manner.
gt; gt;
gt; gt; quot;Gregquot; wrote:
gt; gt;
gt; gt; gt; This is my formula =IF(=OR(Summary!A15lt;gt;quot;H*quot;,Summary!A15lt;gt;quot;P*quot;),=Summ ary!A15))
gt; gt; gt;
gt; gt; gt; What I want to do is if the cell starts with the Letter H or P than I want
gt; gt; gt; to return that cell as the true statment. If not than nothing. What am I
gt; gt; gt; doing wrong. Somebody please help.
gt;

Just to confirm what's been said already... The formula already outputs a
blank if the statement is false. Without the quot;quot; at the end, the formula
would output FALSE. But it should be noted that you can NOT use the ISBLANK
formula to check if it's blank. You will have to use something like this

=IF(B15=quot;quot;,quot;do truequot;,quot;do falsequot;)

I hope this helps.

quot;Gregquot; wrote:

gt; All your help is perfect. Except I want one more piece of the puzzle. I
gt; only want the data from A15 if it starts with an H or P. Is there something
gt; needed if it's a false statement. If it's false I want to return it blank.
gt;
gt;
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; =IF(OR(LEFT(Summary!A15,1)=quot;Hquot;,LEFT(Summary!A15,1) =quot;Pquot;),Summary!A15,quot;quot;)
gt; gt;
gt; gt; you had some eraneous quot;=quot;. Also, the wildcard can't be used in this manner.
gt; gt;
gt; gt; quot;Gregquot; wrote:
gt; gt;
gt; gt; gt; This is my formula =IF(=OR(Summary!A15lt;gt;quot;H*quot;,Summary!A15lt;gt;quot;P*quot;),=Summ ary!A15))
gt; gt; gt;
gt; gt; gt; What I want to do is if the cell starts with the Letter H or P than I want
gt; gt; gt; to return that cell as the true statment. If not than nothing. What am I
gt; gt; gt; doing wrong. Somebody please help.
gt;