Maxinum Percent

[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

 

[Fred Smith]

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.