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
Acknowledge(0)
Amend(0)
9From India, Delhi
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)
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)
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)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Excel VBA_Macro 2 days.pdf
EXCEL FORMULA.xls