Capping a formula value?

  • Thread starter Thread starter Scot B
  • Start date Start date
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.
 
=MIN(formula,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Try this:
=MIN(your_formula,100%)

Does that help?

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

XL2002, WinXP-Pro
 
Back
Top