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
9From India, Delhi
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
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.
Thanks
Ta
From Pakistan, Karachi
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
From Pakistan, Karachi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Excel VBA_Macro 2 days.pdf
EXCEL FORMULA.xls