LEARNING EXCEL (2)

In the LEARNING EXCEL (1) post, we have used an easy way to add (SUM), average (AVERAGE), Nmax and Nmin.

Next in this post we will use the IF function

In the following example the IF function is used to make it easier to recognize the value of students to categorize them into certain classes. See the picture below

The conditions used are:

Column H (Amount of Value) Filled With Total Overall Value

Column I (Final Value) Filled with Average Score

Column J (Department) Filled with IF Function. If the Final Value is greater than 7 then BLUE if the value is greater than 9 then GREEN. Otherwise it's RED

Column K (Class) Filled with IF function. For female gender then class A, if gender is male then class B

So what we need to do is enter the formula using IF in columns H, I, J and K

For column H fill in:

= sum (E6: G6)

For column I fill in:

= average (E6: G6)

already discussed in LEARNING EXCEL (1)

Next for column J fill in:

= IF (I6> = 9; "GREEN"; IF (I6> = 7; "BLUE"; IF (I6 <7; "RED")))

With explanation:

If I6 (average value) is greater or equal to 9 then the class is (J) = GREEN

If I6 is greater or equal to 7, the class is (J) = BLUE

If I6 is smaller than 7 then the class is (J) = RED

Note really the quotes and parentheses, because it will affect the results

Next for column K fill in:

= IF (D6 = "M"; "B"; "A")

With explanation:

If D6 (Gender / gender) is equal to M, then class B

If D6 is not equal to M, then class A

Next for the next lines, we can use copy paste, by the way. Highlight the column that you want to copy then right click and select copy

Then highlight where you want to paste, and right-click then select paste

VERY EASY

RELATED ARTICLE/ARTIKEL TERKAIT