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 (Download Requires Membership)
File Type: xls Excel Formula.xls (1.48 MB, 25182 views)

Acknowledge(0)
Amend(0)

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
Acknowledge(0)
Amend(0)

Hi all,

I need some help to get an Excel formula for the following categories based on percentage ranges:
- 90%-100%: Outstanding
- 76%-89%: Very Good
- 60%-75%: Good
- 45%-59%: Fair
- 31%-44%: Needs Improvement
- 0%-30%: Unsatisfactory

This is for a performance appraisal (PA) sheet. I require a formula that will automatically display the corresponding category (e.g., Good, Very Good) based on the total percentage of marks received.

Thank you,
Ta

From Pakistan, Karachi
Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.