HOW TO
COMMENT [REMARKING] DATA [SCORES] IN EXCEL
[Comment,
Remarks, Fail, Pass, . . . ]
use '' =IF(
)
''
NOTE
: We can comment total data or average data.
I.FIND
THE AVERAGE OF SCORES (at cell E2)
- Have a data into cells [that are to be average calculated] Example [13 + 25 + 14] ÷ 3
=AVERAGE(13;25;14)
- Identify the column name and row name
Example
Columns
[B, C and D]
and Row
[2]
…....... Horizontal calculation
OR
Column
[B]
and Rows
[2,3,4 and 5]
…........ Vertical calculation
- Identify the range of data into cells [that are to be average calculated]
Example
B2 to D2 (B2:D2)
- Syntax: '' = AVERAGE(B2:D2) ''
II. PASS/FAIL
- If average score is above 50, then PASS, otherwise FAIL.
- Syntax: '' = IF(E2>=50;”PASS”;”FAIL”) ''
III. COMMENTS
- If average score is below 50, then REPEAT COURSE, otherwise AWARDED.
- Syntax: '' = IF(E2<=50;”REPEAT COURSE”;”AWARDED”) ''
NOTE:
In writing formula, use semi-colon [;] if you use OpenOffice
otherwise use comma only [,] if you use Microsoft office
OTHER EXCEL FUNCTIONS [SYNTANX]
Thank you sharing this kind of noteworthy information. Nice Post.
ReplyDeletebusinessexceltemplates
Article submission sites
I esteem what you've got completed here. I between the portion where you're making feedback on you're do something this to pay for by way of now but i might admit by using all the feedback that that is powerful for you as ably. Advanced Excel Training Mumbai
ReplyDelete