Formula help Urgent

[sushantrao]

Hi All

Calculator.xls
	B	C	D	E
2	Days	Target SLA	Achived SLA	Req SLA
3
4	1	90	50
5	2	90	30
6	3	90	50
7	4	90		?
8	5	90		?
9	6	90		?
10		90		?
11	30	90		?
12
13		90	43
Sheet1

In above tabel in ? place i want the that % rate which help me to
achive 90% SLA target.

I want to prepre one tabel in which i know the % rate req for the achivement of SLA. for rest of the month days.

Eg : if I achive 43.33% Average SLA for first 3 days of the month
then what % rate needs to be maintain to achive target SLA for rest of 27 days.& that % rate will automatically come in Req SLA column in the place of ? ? .....


Reagrds,
Sushant

 

[Peter_SSs]

sushantrao

I am not sure that I have understood correctly, but see if this helps.

I have assumed that the numbers in column B continue sequentially further down the sheet so that 30 is actually in cell B33. If that is the case, in E4 (copied down) try this formula:
=IF(D4="",(B$33*C$33-SUM(D$4:D4))/(B$33-COUNT(D$4:D4)),"")

If this is not what you want, post back with more details.