My eyes must be going - I didn't spot that until I read your
correction !!

Pete

On Jul 12, 9:38 pm, "Sandy Mann" wrote:
My Spelling checker doesn't work in OE I meant of course parenthesis!

--
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

...



OK take the extra perenthsis off (and don't let XL correct formulas for
you!) <g

=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
...
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.- Hide quoted text -

- Show quoted text -