And before someone comes back and says it. Put 0.11 in a cell and use:

=MAX(100,(MIN(M1*N1,225)))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
I think that the OP wanted an IF() but just for variety:

=MAX(100,(MIN(M1*0.11,225)))

Rick Rothstein will like it because it's shorter <g
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jen" wrote in message
...
I am having some trouble with this. I have this worksheet on loans. I
have
to calculate a fee for each loan. ex: M1*.011=x. If x<100, it has to
be
changed to 100. If x225, it has to be changed to 225. If x is between
100
and 225, it stays that number. I'm trying to create an IF formula that
will
take the numbers <100 and change them to 100 and take those 225 and
change
them to 225, all the while keeping the numbers between 100 and 225 the
same....any help? The only thing I've been able to create is a response
of
true or false, a response of only 100, or a response of only 225.