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
From India, Delhi

Attached Files
File Type: xls Excel Formula.xls (1.48 MB, 25028 views)

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

From India
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.

From Pakistan, Karachi

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Com™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server