Capping a formula value?

[Scot B]

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]

=MIN(formula,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scot B" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

[Ron Coderre]

Try this:
=MIN(your_formula,100%)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Scot B" wrote:

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