Capping a formula value?

S

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

Bob Phillips

=MIN(formula,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
R

Ron Coderre

Try this:
=MIN(your_formula,100%)

Does that help?

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

XL2002, WinXP-Pro
 
Top