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