Traderjoe56
New Member
- Joined
- Jun 22, 2011
- Messages
- 9
Hi everyone,
I want to start out by thanking anyone ahead of time for helping out with this problem.
I'm still a bit of a noob with excel formulas, so I'm hoping this question's not to assinine... but in any case, I have a list of countries in column A, and some value for each country in Column B . what I would like to have is a formula that looks at Column B, compares it with some constant, and if it's below that number, list it, or else, keep hunting for all values below some constant. so for example:
A B Countries below 20
Australia 32 Armenia
Armenia 10 Brazil
Barbados 22
Brazil 9
I'm thinking that last column needs a formula that goes
=if(B2<20, A2, _________)
where blank is the command that makes it go to the next row and run the same formula again.
thanks for the help!
Joe
I want to start out by thanking anyone ahead of time for helping out with this problem.
I'm still a bit of a noob with excel formulas, so I'm hoping this question's not to assinine... but in any case, I have a list of countries in column A, and some value for each country in Column B . what I would like to have is a formula that looks at Column B, compares it with some constant, and if it's below that number, list it, or else, keep hunting for all values below some constant. so for example:
A B Countries below 20
Australia 32 Armenia
Armenia 10 Brazil
Barbados 22
Brazil 9
I'm thinking that last column needs a formula that goes
=if(B2<20, A2, _________)
where blank is the command that makes it go to the next row and run the same formula again.
thanks for the help!
Joe