Excel Formula - Work Days Calculations - XLS Download

Ajeetmx
Hi Again all,
I am very happy to hear that you all liked the previous attachment.Now see this attachment.i also received this attachment from a CiteHR member.
regards,
Amarjeet
1 Attachment(s) [Login To View]

V.Raghunathan
Dear Mr Amarjeet
A very good Xl file.
I sampled a few tips.
There is an error in Power calculation “to calculate the area of circle”
given in row 249.
The solution given is =P()*(C22,2)
It should read=P()*(C24,2)
V.Raghunathan..................................... ............... Navi Mumbai
Tariq_HR
Hi All,
I need some help to get an excel formula for the below:
90%-100% Outstanding
76%-89% Very Good
60%-75% Good
45%-59% Fair
31%-44% Needs Improvement
0%-30% Unsatisfactory
Now as you can see the above is for PA sheet. I need a formula which will automatically show the Category e.g Good, very good etc according to the total percentage of marks he/she has received.
Thanks
Ta
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute