Need help with an if/then formula

[Mile029]

Hi, I have attached a sheet with sample data and Column AA states what I need. I have manually entered what the if / then statment should produce. Please if anyone can make or not make this statement, let me know. Basically I need a True False result in coloumn AA depending on if the next col over has any value in it. Please lte me know thank you.

[CLR]

In AA1 put this and copy down.........

=IF(LEN(AB1)>0,"True","False")

Vaya con Dios,
Chuck, CABGx3


"Mile029" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, I have attached a sheet with sample data and Column AA states what I
> need. I have manually entered what the if / then statment should
> produce. Please if anyone can make or not make this statement, let me
> know. Basically I need a True False result in coloumn AA depending on
> if the next col over has any value in it. Please lte me know thank
> you.
>
>
> +-------------------------------------------------------------------+
> |Filename: Sample CBK BIN Query2.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=3929 |
> +-------------------------------------------------------------------+
>
> --
> Mile029
> ------------------------------------------------------------------------
> Mile029's Profile:
http://www.excelforum.com/member.php...o&userid=21091
> View this thread: http://www.excelforum.com/showthread...hreadid=478054
>

[Chip Pearson]

Few people will open attachments due to the possibility of
nefarious code. Describe your problem in the body of your message
and someone will likely answer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mile029" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi, I have attached a sheet with sample data and Column AA
> states what I
> need. I have manually entered what the if / then statment
> should
> produce. Please if anyone can make or not make this statement,
> let me
> know. Basically I need a True False result in coloumn AA
> depending on
> if the next col over has any value in it. Please lte me know
> thank
> you.
>
>
> +-------------------------------------------------------------------+
> |Filename: Sample CBK BIN Query2.zip
> |
> |Download: http://www.excelforum.com/attachment.php?postid=3929
> |
> +-------------------------------------------------------------------+
>
> --
> Mile029
> ------------------------------------------------------------------------
> Mile029's Profile:
> http://www.excelforum.com/member.php...o&userid=21091
> View this thread:
> http://www.excelforum.com/showthread...hreadid=478054
>

[Mile029]

Sorry about that, here is a sample of what I'm talking about. I really need help with this:

For each Row, if there are values considering even 0%, (Not NULL, or empty) in subsequent months, following the earliest month in which the Row shows 10% or greater, return True. See sample above.

I need the True/False formula in column AA

Please let me know. Thank you.

[Mile029]

anyone see a way to figure this out, or is it a lost cause. Please advise. Thank you.

[CLR]

Well, this info changes things a bit, and yes, it can be done in Excel, but
I can't think of just an easy formula to put in column AA to do the
job........
Here's my solution..........
Assuming your data as given is in A1:E6 with the months in row A.........
Then in A10 put this formula and copy down to A14
=IF(A2>10%,1,"")
Then in B10 put this and copy across to E10, and down to E14
=IF(AND(A2>10%,B2>=0%),1,"")
then in G1 put this formula and copy down to G14
=IF(SUM(A10:E10)>1,"TRUE","FALSE")

It ain't clean, but it does the job, and of course the new "table" can be
hidden or on another sheet, etc..........

Vaya con Dios,
Chuck, CABGx3



"Mile029" <[email protected]> wrote in
message news:[email protected]...
>
> Sorry about that, here is a sample of what I'm talking about. I really
> need help with this:
>
> Jan Feb Mar Apr
> May AA
> 1 900% 0% 0% 0% empty
> True
> 2 0% 500% empty empty empty
> False
> 3 400% 0% 0% empty empty
> True
> 4 200% 100% 100% 700% empty
> True
> 5 0% 0% 0% 100% empty
> False
> For each Row, if there are values considering even 0%, (Not NULL, or
> empty) in subsequent months, following the earliest month in which the
> Row shows 10% or greater, return True. See sample above.
>
> I need the True/False formula in column AA
>
> Please let me know. Thank you.
>
>
> --
> Mile029
> ------------------------------------------------------------------------
> Mile029's Profile:
http://www.excelforum.com/member.php...o&userid=21091
> View this thread: http://www.excelforum.com/showthread...hreadid=478054
>

[Mile029]

I see where you are going with this and kinda understand what the result would be, but the problem is I have over 10000 rows to work with and going back to 2001 by month. So that sample data above doesn't even scratch the surface of what I'm working with.

Also I tried the formula with the data that I provided and it didn't work. Sorry. Hope there is a better way.