Whatif statement

[risailor]

I have been asked to add a whatif statement to a table I am building. The issue is that the variable measurement that is being played with could end up exceeding the total number of calls offered. (see example)

Example

January Calls Offered 244
Calls Met SLA 198
Incremental Headcount 4 (assumption is analyst can handle 5 calls per hour)
Additional Calls Able to Manage = 20 (Incremental Headcount x 5)
Total New Calls Met SLA 20 (Incremental headcount plus Calls Met SLA) 218

Because you can never obtain higher than 100% compliance, the Total New Calls Met SLA cannot be higher than Calls Met SLA.

To solve this I was told to build a Whatif statement into Total New Calls Met SLA so it never exceeds this.

 

[Dryver14]

you have a few choices here

assume standard count is in A3
and new count is in A10

you could in A11 have a formula like this

=IF(A10>A3,"Exceeded","")

or you can conditional format the cell in 2007 or greater you can select the cell A10 then highlight cell rules and say >A3 and let it change colour.

 

[risailor]

"=IF(A10>A3,"Exceeded","")

or you can conditional format the cell in 2007 or greater you can select the cell A10 then highlight cell rules and say >A3 and let it change colour"

************
Thanks for the help. I need to get one thing out of this specifically based on my result for New Total Meeting SLA.

I need to determine the overall achieved % (ex 2788/2899 = 96.17%). Based on your response, I was not sure what value to put into the New Total Meeting SLA field. Would it simply be "IF=A2>A1,"A1"?

If New Total Meeting SLA value (2788) is = or > Calls Answered (2899) the value will be equal to Calls Answered (2899)?

If that is the case, the SLA % will never be over 100%

Sorry if that is confusing.

 

[Dryver14]

Its a little confusing..hav you worked out already your starting value and end value?

I have no clue how many hours are left or operators allocated to the task

If Totl allowed in A1 was 200
If start value in A2 was 180
Operators allocted in A3 was 4
Time left was in A4 was 3 hours


A5 =(A2+((A3*5)*A4)) then in A6 =IF(A5>A1,"Exceeded","")