If AND Formula Help

[Apples52]

Hi,

I am trying to get this formula to say If cell B is greater than 0, AND cell G is less than 2000, return value H. The formula is in column J. You can see the text of that formula I've pasted in column K.

In row 1 and 2, I've got the first half of the formula I want to work. However, in row 3 when I try to exclude values in column G that are 2000 and greater using an "AND" statement, it's not working. I've tried a few different "AND" statements, but can't get the formula to return a "0" value for account numbers greater than 2000 in column G.

[For background, colum B is a store number and column G are account numbers, where assets are in the 1000's and liabilites are in the 2000's. I only want assets values (column G) that also have a store number (column B)].

Can you help show me where I'm going wrong?

 

[dreid1011]

What about this:

=IF(AND(B1>0,G1<2000),H1,0)

 

[Apples52]

What about this:

=IF(AND(B1>0,G1<2000),
[/QUOTE]

Yes, worked, thanks so much!

 

[dreid1011]

You're welcome, and happy to help.