Hi Shweta,

Do you mean the additional score with that amount of responses in order to
achieve CSAT = 4.65?
Then it will be 4.65*response - score.
let say A1 = 706 (score), B1 = 153 (response), your formula should be
"=4.65*B1-A1 & " fig. required to be 4.65"

"Shweta Srivastava" wrote:

Hi there,

Please help me with the following issue.

I maintain a worksheet which aims to achieve customer satisfaction rate to
be 4.65


For example:

Total Total Customer Satisfaction
Target for
Score Responses (CSAT) rate (CSAT=4.65)
706 153 4.61 (706/153) ? fig. required to be 4.65
192 44 4.36 (192/44) ? fig. required to be 4.65
359 85 4.22 (359/85) ? fig. required to be 4.65
500 250 2.00 (500/250) ? fig. required to be 4.65
500 120 4.17 (500/120) ? fig. required to be 4.65


What function/formula can give me the figures to achieve the above mentioned
CSAT Target to 4.65?


Regards,
Shweta