TUGAS XI IPA 2

2 thoughts on “TUGAS XI IPA 2

  1. syahila zulfa nadira (XI. IPA 2)

    1. Lama Menginap
    • Rahayu -> Rumus =E5-D5 => Hasil (3)
    • Santi -> Rumus =E6-D6 => Hasil (3)
    • Putri -> Rumus =E7-D7 => Hasil (3)
    • Eka -> Rumus =E8-D8 => Hasil (3)
    • Icha -> Rumus =E9-D9 => Hasil (3)

    2. Biaya Inap
    • Rahayu -> Rumus =D14*F5 => Hasil (300.000 x 3 = 900.000)
    • Santi -> Rumus =D16*F6 => Hasil (100.000 x 3 = 300.000)
    • Putri -> Rumus =D15*F7 => Hasil (200.000 x 3 = 600.000)
    • Eka -> Rumus =D14*F8 => Hasil (300.000 x 3 = 900.000)
    • Icha -> Rumus =D15*F9 => Hasil (200.000 x 3 = 600.000)

    3. Biaya Layanan
    • Rahayu -> Rumus =E14*F5 => Hasil (1.000.000 x 3 = 3.000.000)
    • Santi -> Rumus =E16*F6 => Hasil (50.000 x 3 = 150.000)
    • Putri -> Rumus =E15*F7 => Hasil (70.000 x 3 = 210.000)
    • Eka -> Rumus =E14*F8 => Hasil (1000.000 x 3 = 3.000.000)
    • Icha -> Rumus =E15*F9 => Hasil (70.000 x 3 = 210.000)

    4. Biaya Persalinan
    • Rahayu -> Rumus =D19*F5 => Hasil (1000.000 x 3 = 3.000.000)
    • Santi -> Rumus =D19*F6 => Hasil (1000.000 x 3 = 3.000.000)
    • Putri -> Rumus =D20*F7 => Hasil (750.000 x 3 = 2.250.000)
    • Eka -> Rumus =D20*F8 => Hasil (750.000 x 3 = 2.250.000)
    • Icha -> Rumus =D20*F9 => Hasil (750.000 X 3 = 2.250.000)

    5. Total Biaya
    • Rahayu -> Rumus =G5+H5+I5 => Hasil (6.900.000)
    • Santi -> Rumus =G6+H6+I6 => Hasil (3.450.000)
    • Putri -> Rumus =G7+H7+I7 => Hasil (3.060.000)
    • Eka -> Rumus =G8+H8+I8 => Hasil (6.150.000)
    • Icha -> Rumus =G9+H9+I9 => Hasil (3.060.000)

  2. 1. Lama Menginap
    • Rahayu -> Rumus =E5-D5 => Hasil (3)
    • Santi -> Rumus =E6-D6 => Hasil (3)
    • Putri -> Rumus =E7-D7 => Hasil (3)
    • Eka -> Rumus =E8-D8 => Hasil (3)
    • Icha -> Rumus =E9-D9 => Hasil (3)

    2. Biaya Inap
    • Rahayu -> Rumus =D14*F5 => Hasil (300.000 x 3 = 900.000)
    • Santi -> Rumus =D16*F6 => Hasil (100.000 x 3 = 300.000)
    • Putri -> Rumus =D15*F7 => Hasil (200.000 x 3 = 600.000)
    • Eka -> Rumus =D14*F8 => Hasil (300.000 x 3 = 900.000)
    • Icha -> Rumus =D15*F9 => Hasil (200.000 x 3 = 600.000)

    3. Biaya Layanan
    • Rahayu -> Rumus =E14*F5 => Hasil (1.000.000 x 3 = 3.000.000)
    • Santi -> Rumus =E16*F6 => Hasil (50.000 x 3 = 150.000)
    • Putri -> Rumus =E15*F7 => Hasil (70.000 x 3 = 210.000)
    • Eka -> Rumus =E14*F8 => Hasil (1000.000 x 3 = 3.000.000)
    • Icha -> Rumus =E15*F9 => Hasil (70.000 x 3 = 210.000)

    4. Biaya Persalinan
    • Rahayu -> Rumus =D19*F5 => Hasil (1000.000 x 3 = 3.000.000)
    • Santi -> Rumus =D19*F6 => Hasil (1000.000 x 3 = 3.000.000)
    • Putri -> Rumus =D20*F7 => Hasil (750.000 x 3 = 2.250.000)
    • Eka -> Rumus =D20*F8 => Hasil (750.000 x 3 = 2.250.000)
    • Icha -> Rumus =D20*F9 => Hasil (750.000 X 3 = 2.250.000)

    5. Total Biaya
    • Rahayu -> Rumus =G5+H5+I5 => Hasil (6.900.000)
    • Santi -> Rumus =G6+H6+I6 => Hasil (3.450.000)
    • Putri -> Rumus =G7+H7+I7 => Hasil (3.060.000)
    • Eka -> Rumus =G8+H8+I8 => Hasil (6.150.000)
    • Icha -> Rumus =G9+H9+I9 => Hasil (3.060.000)

Tinggalkan Pesan Anda Disini

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s