Blank Space pt.2

Latihan 1

=IF(E5="S3";25000000;IF(E5="S2";20000000;IF(E5="S1";15000000;IF(E5="D3";1000000;0)))) 

=IF(E6="S3";25000000;IF(E6="S2";2000000;IF(E6="S1";15000000;IF(E6="D3";1000000;0))))

=IF(E7="S3";25000000;IF(E7="S2";2000000;IF(E7="S1";15000000;IF(E7="D3";1000000;0))))

=IF(E8="S3";25000000;IF(E8="S2";20000000;IF(E8="S1";15000000;IF(E8="D3";10000000;0))))

=IF(E9="S3";25000000;IF(E9="S2";20000000;IF(E9="S1";15000000;IF(E9="D3";1000000;0))))

Latihan 2

JUMLAH SISWA HADIR   =COUNTA(C5:C19)

JUMLAH SISWA SAKIT =COUNTIF(G5:G19;"SAKIT")

JUMLAH SISWA ALFA =COUNTIF(G6:G20;"SAKIT")

JUMLAH SISWA IZIN =COUNTIF(G7:G21;"SAKIT")

Latihan 3

1. Total jual     =SUM(G6:J6)

2. Keuntungan       =(F6-E6)*L6

Total jual

Tkeseluruhan     =SUM(L6:L10)

Ttertinggi      =MAX(K6:K10)

Tterendah     =MIN(K6:K10)

Rta²    =AVERAGE(K6:K10)

Record      =COUNTA(A6:A10)

Latihan 4

Ttugas     =AVERAGE(D7:F7)

Tquiz      =AVERAGE(G7:H7)

Tnilai      =(I7+J7)/2

Grade         =IF(K7>=80;"A";IF(K7>=59;"B";IF(K7>=40;"C";"D")))

— Blank Space.

 Spreadsheet

=IF(B2>=75;"REFANIA";"RAYYA")

Excel

=IF(B8>75;"REFANIA";"RAYYA")

𝘚𝘰 𝘏𝘪𝘨𝘩𝘴𝘤𝘩𝘰𝘰𝘭.

Before:

After:

Before:

After:

Before:

After:

Miss u.

𝐶𝑎𝑠𝑡.

 

—𝐿𝑒𝑒 𝐾𝑛𝑜𝑤. 𝑇ℎ𝑒 𝑃𝑖𝑛𝑘 𝑡𝑜 𝑡ℎ𝑒 𝐺𝑟𝑒𝑒𝑛. 

—𝐻𝑎𝑛 𝐽𝑖𝑠𝑢𝑛𝑔. 𝑇ℎ𝑒 𝐺𝑟𝑒𝑒𝑛 𝑡𝑜 𝑡ℎ𝑒 𝑃𝑖𝑛𝑘.

𝘓𝘰𝘷𝘦 𝘮𝘦 𝘰𝘳 𝘓𝘦𝘢𝘷𝘦 𝘮𝘦.

𝐵𝑜𝑟𝑛 𝑡𝑜 𝑑𝑖𝑒.

"Thats okay if you want to take a diamond of mine." -Han Jisung

"My pleasure." -Lee Know