HOW TO
FIND PERCENTAGE AND FACTORIAL OF DATA [SCORES] IN EXCEL
Procedures and concepts to
consider:
- Have a data into cells [that are to be processed] Example 13,25,14,65, . . .
- Identify the column name and row name
- Identify the range of data into cells [that are to be processed]
- Example B3 to E3 (B3:E3)
COUNT
ALL SIMILAR DATA [Count
All Grade in a Column / Row]
If
Cell
F
with a range F3:F8,
then
If
75 – 100 = A,
65 – 74 = B,
45 – 64 = C,
30 – 44 = D
and 0 – 29.9 = F
- Syntax: '' = COUNTIFS(F3:F8;''>=75'';F3:F8;''<=100'') '' …...Counting all A
- Syntax: '' = COUNTIFS(F3:F8;''>=65'';F3:F8;''<=74'') '' …...Counting all B
- Syntax: '' = COUNTIFS(F3:F8;''>=45'';F3:F8;''<=64'') '' …...Counting all C
- Syntax: '' = COUNTIFS(F3:F8;''>=30'';F3:F8;''<=44'') '' …...Counting all D
- Syntax: '' = COUNTIFS(F3:F8;''>=0'';F3:F8;''<=29.9'') '' …...Counting all F
PERCENTAGE OF GRADES
If
total number of candidate is 6,
then take number of grade divide
by 6
and multiply
by 100%
- Syntax: '' = ((I3/6)*100)% ''
FACTORIAL [Factorial ! of a
number]
Example
factorial of 3 = 3x2x1
= 6
- Syntax: '' = FACT(B2) ''
TO FIND FUNCTION
Example
find all ''LE''
from ''APPLE''
; that will ''L
+ E
+ E
+ L
'' = 4
- Syntax: '' = FIND(A2;B2) ''
NOTE:
In writing formula, use semi-colon [;] if you use OpenOffice
otherwise use comma only [,] if you use Microsoft office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment