Maxinum Percent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to cap the maxium value no matter the measured values

Example

A= target desire
b= target achieve
c=% of desired target achieved.

B(7.5)/A(5)=150

C % Of target achived(150%) * Percent of total (15%) = 22.5

I need to cap the % of total at 20% of 15% (18%) no matter how high the % of target achieved is

Can a formula be written for this

Thanks
 
It looks to me like you want to cap it at 120%, not 20%. Regardless, to cap
any number use the Min function:

=min(cap,c1)

If c1 > cap, you'll get cap as the result.
 
Back
Top