Fun Excel Exercise IF Function

IF Function in Excel is condition is true or false.
This my excel exercise IF function:
Function script: =IF(logical_test,[value_if_true],[value_if_false])

Fun manual cell fill (B2):
=IF(A2="b","black",IF(A2="w","white","grey"))

Copy function down.

My Basic Excel Function Exercise

Today I want to share my basic excel function exercise.
Target function: SUM, AVERAGE, COUNT, MAX and MIN.

Function script:
=SUM(number1;[number2];...)
=AVERAGE(number1;[number2];...)
=COUNT(value1;[value2];...)
=MAX(number1;[number2];...)
=MIN( number1;[number2];...)

Manual cell fill:
B12  :    =SUM(b2:b11)

B13  :    =COUNT(b2:b11)
B14  :    =AVERAGE(b2:b11)
B15  :    =MAX(b2:b11)
B16  :    =MIN(b2:b11)

My First Post

Hello world, I'm young man from Sleman Jogjakarta Indonesia.

I'm interested in excel. I want to share my excel exercises.  So, Enjoy my blog.

FY Noor