IF formulas

[Lori]

I am trying to create a formula that performs the following answer: If this,
then this, or this, but not > this. The "not > this" part is what I cannot
figure out. Here is the formula I have so far:

IF(I7<7000,7000-E7,"0")

I need to add a qualifier to the 'value if true' part of the formula that
keeps the answer no greater than the figure in E7. Is this a valid formula?

Thanks!

 

[Gary''s Student]

For "this, but not greater than 7000"
use
MIN(I7,7000)

 

[Mike H]

Maybe

=IF(I7<7000,MIN(E7,7000-E7),"0")

Mike

 

[Fred Smith]

And you probably want to remove the quotes around the final zero.

Regards,
Fred.