formula help!!!!

[George Felton]

Complicated question...





Actual # achieved/Target # = %. This % I have already in
a formula. This % achieved is then multiplied by the
percentage this items counts to the total % (100) Example:

Achieved= 6.5% / Target= 6.5% = 100% of the goal set.
This measure is 15% of the total of all measures. I want
to cap the maximum % available no matter how much the
actual amount achieved %verses the target % is at 120%
(or 18%)

 

[A.W.J. Ales]

George,

I'm not sure to understand you, but if you mean that the % you calculate
should never be more than 120% you probably need :

=Min( %achieved / %target , 120% )

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Guest]

the formula i have is as follow

(f7/c7)*(.15) (where 15% is part of the 100%
6.5%/9.75*.15 = 27

i want the maxinum % after measure to be no more than 18%

 

[Guest]

Clarificatio

the max is 120% of 15

George

 

[A.W.J. Ales]

George,

Sorry, I still don't understand you.
In my calculations 6.75% / 9.75 * 0.15 = 10% tather then 27%.

However I still think that you migth need the Min function.
This because I still have the impression you want to perform a calculation,
compare the result with a preset maximum and (if that maximum is lower than
your calculated result ) take that preset maximum as final answer, but that
you want (if the calculated result is lower than the maximum) take the
result of the calculation as final result.

If that describes somehow what you want to do then :

=Min(Your calculation,Preset maximum) is exactly doing that.

If : Your calculation > Preset Maximum the output from this function is :
Preset Maximum
If : Your calculation <= Preset Maximum the output from this function is :
Your calculation


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *