Need help with an if/then formula

  • Thread starter Thread starter Mile029
  • Start date Start date
M

Mile029

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

+-------------------------------------------------------------------
|Filename: Sample CBK BIN Query2.zip
|Download: http://www.excelforum.com/attachment.php?postid=3929
+-------------------------------------------------------------------
 
In AA1 put this and copy down.........

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

Vaya con Dios,
Chuck, CABGx3
 
Sorry about that, here is a sample of what I'm talking about. I reall
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, o
empty) in subsequent months, following the earliest month in which th
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
 
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
 
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.
 
Back
Top