The logic is the same - exactly as you have it in your example with the
Minimum/Maximum for Target.

It does not matter whether the target is up/down - the calculation works out
what is required to reach a stated figure. So if you do not want to exceed
10%, then your next 3 week average must be no more than 13% [or 19% maximum].

It is up to you on how you interpret the data.

Or have I misunderstood your requirement?

HTH

"asim" wrote:


Tommy, Pure Brilliance! - thankyou ever so much - just what I needed.

How would I change the forumla if I was working towards a Target which
is in the opposite direction of the algorithm you have provided, i.e.
The target should not achieve more than 90%, the absolute target is
92%.

Therefore, anything greater than 90% is bad, but 92% is a no-no?

Is this a simple change?

I have attached the spreadsheet - the data set in columns G-K, is where
the query is.


Thanks again.


+-------------------------------------------------------------------+
|Filename: SLA violation example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4903 |
+-------------------------------------------------------------------+

--
asim
------------------------------------------------------------------------
asim's Profile: http://www.excelforum.com/member.php...o&userid=35530
View this thread: http://www.excelforum.com/showthread...hreadid=552972