Greetings, Experts,
Thanks for reading this message.
I'm trying to figure a formula that reaches a cap, and if the formula wants
to return a value over the cap, it displays the cap. if it is below the
cap, it returns the formula value.
More specifically, i'm figuring out a percentage, but if the percentage from
the formula wants to be over 100%, it should just return 100%.
Any suggestions?
Thanks!
Scot B.
Bob Phillips - 27 Dec 2005 23:35 GMT
=MIN(formula,1)

Signature
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
> Greetings, Experts,
>
[quoted text clipped - 12 lines]
>
> Scot B.
Ron Coderre - 27 Dec 2005 23:40 GMT
Try this:
=MIN(your_formula,100%)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
> Greetings, Experts,
>
[quoted text clipped - 12 lines]
>
> Scot B.