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