For "this, but not greater than 7000"
use
MIN(I7,7000)
--
Gary''s Student - gsnu200829


"Lori" wrote:

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!


--
Lori