Thread
:
Getting a response other than true/false with an IF formula
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Getting a response other than true/false with an IF formula
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.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann