Hal pertama,buatlah struktur datanya seperti gambar di atas.kali ini saya akan memulai mencoba belajar sebuah hasil perhitungan digital menggunakan Microsoft exel.bagi yang baru belajar bagaimana cara untuk membuat hasil total di microsoft exel,perhatikan baik-baik.
Setelah seperti gambar di atas yang sudah kita buat,cobalah isi di kolom bagian Ope1 dengan sebuah angka misalkan 50.000.00 (lima puluh ribu rupiah)
Untuk rumusnya sebagai berikut:
RUMUS UANG KAS
=B5+C5+D5
=B6+C6+D6
=B7+C7+D7
=B8+C8+D8
=B9+C9+D9
=B10+C10+D10
=B11+C11+D11
=B12+C12+D12
=B13+C13+D13
=B14+C14+D14
=B15+C15+D15
=B16+C16+D16
=B17+C17+D17
=B18+C18+D18
=B19+C19+D19
=B20+C20+D20
=B21+C21+D21
=B22+C22+D22
=B23+C23+D23
=B24+C24+D24
=B25+C25+D25
=B26+C26+D26
=B27+C27+D27
=B28+C28+D28
=B29+C29+D29
=B30+C30+D30
=B31+C31+D31
=B32+C32+D32
=B33+C33+D33
=B34+C34+D34
=B35+C35+D35
RUMUS TOTAL SALDO
=L4+B5+C5+D5-F5-G5-H5-I5-J5-K5
=L5+B6+C6+D6-F6-G6-H6-I6-J6-K6
=L6+B7+C7+D7-F7-G7-H7-I7-J7-K7
=L7+B8+C8+D8-F8-G8-H8-I8-J8-K8
=L8+B9+C9+D9-F9-G9-H9-I9-J9-K9
=L9+B10+C10+D10-F10-G10-H10-I10-J10-K10
=L10+B11+C11+D11-F11-G11-H11-I11-J11-K11
=L11+B12+C12+D12-F12-G12-H12-I12-J12-K12
=L12+B13+C13+D13-F13-G13-H13-I13-J13-K13
=L13+B14+C14+D14-F14-G14-H14-I14-J14-K14
=L14+B15+C15+D15-F15-G15-H15-I15-J15-K15
=L15+B16+C16+D16-F16-G16-H16-I16-J16-K16
=L16+B17+C17+D17-F17-G17-H17-I17-J17-K17
=L17+B18+C18+D18-F18-G18-H18-I18-J18-K18
=L18+B19+C19+D19-F19-G19-H19-I19-J19-K19
=L19+B20+C20+D20-F20-G20-H20-I20-J20-K20
=L20+B21+C21+D21-F21-G21-H21-I21-J21-K21
=L21+B22+C22+D22-F22-G22-H22-I22-J22-K22
=L22+B23+C23+D23-F23-G23-H23-I23-J23-K23
=L23+B24+C24+D24-F24-G24-H24-I24-J24-K24
=L24+B25+C25+D25-F25-G25-H25-I25-J25-K25
=L25+B26+C26+D26-F26-G26-H26-I26-J26-K26
=L26+B27+C27+D27-F27-G27-H27-I27-J27-K27
=L27+B28+C28+D28-F28-G28-H28-I28-J28-K28
=L28+B29+C29+D29-F29-G29-H29-I29-J29-K29
=L29+B30+C30+D30-F30-G30-H30-I30-J30-K30
=L30+B31+C31+D31-F31-G31-H31-I31-J31-K31
=L31+B32+C32+D32-F32-G32-H32-I32-J32-K32
=L32+B33+C33+D33-F33-G33-H33-I33-J33-K33
=L33+B34+C34+D34-F34-G34-H34-I34-J34-K34
=L34+B35+C35+D35-F35-G35-H35-I35-J35-K35
=L34+B35+C35+D35-F35-G35-H35-I35-J35-K35
Untuk rumusnya sebagai berikut:
RUMUS UANG KAS
=B5+C5+D5
=B6+C6+D6
=B7+C7+D7
=B8+C8+D8
=B9+C9+D9
=B10+C10+D10
=B11+C11+D11
=B12+C12+D12
=B13+C13+D13
=B14+C14+D14
=B15+C15+D15
=B16+C16+D16
=B17+C17+D17
=B18+C18+D18
=B19+C19+D19
=B20+C20+D20
=B21+C21+D21
=B22+C22+D22
=B23+C23+D23
=B24+C24+D24
=B25+C25+D25
=B26+C26+D26
=B27+C27+D27
=B28+C28+D28
=B29+C29+D29
=B30+C30+D30
=B31+C31+D31
=B32+C32+D32
=B33+C33+D33
=B34+C34+D34
=B35+C35+D35
RUMUS TOTAL SALDO
=L4+B5+C5+D5-F5-G5-H5-I5-J5-K5
=L5+B6+C6+D6-F6-G6-H6-I6-J6-K6
=L6+B7+C7+D7-F7-G7-H7-I7-J7-K7
=L7+B8+C8+D8-F8-G8-H8-I8-J8-K8
=L8+B9+C9+D9-F9-G9-H9-I9-J9-K9
=L9+B10+C10+D10-F10-G10-H10-I10-J10-K10
=L10+B11+C11+D11-F11-G11-H11-I11-J11-K11
=L11+B12+C12+D12-F12-G12-H12-I12-J12-K12
=L12+B13+C13+D13-F13-G13-H13-I13-J13-K13
=L13+B14+C14+D14-F14-G14-H14-I14-J14-K14
=L14+B15+C15+D15-F15-G15-H15-I15-J15-K15
=L15+B16+C16+D16-F16-G16-H16-I16-J16-K16
=L16+B17+C17+D17-F17-G17-H17-I17-J17-K17
=L17+B18+C18+D18-F18-G18-H18-I18-J18-K18
=L18+B19+C19+D19-F19-G19-H19-I19-J19-K19
=L19+B20+C20+D20-F20-G20-H20-I20-J20-K20
=L20+B21+C21+D21-F21-G21-H21-I21-J21-K21
=L21+B22+C22+D22-F22-G22-H22-I22-J22-K22
=L22+B23+C23+D23-F23-G23-H23-I23-J23-K23
=L23+B24+C24+D24-F24-G24-H24-I24-J24-K24
=L24+B25+C25+D25-F25-G25-H25-I25-J25-K25
=L25+B26+C26+D26-F26-G26-H26-I26-J26-K26
=L26+B27+C27+D27-F27-G27-H27-I27-J27-K27
=L27+B28+C28+D28-F28-G28-H28-I28-J28-K28
=L28+B29+C29+D29-F29-G29-H29-I29-J29-K29
=L29+B30+C30+D30-F30-G30-H30-I30-J30-K30
=L30+B31+C31+D31-F31-G31-H31-I31-J31-K31
=L31+B32+C32+D32-F32-G32-H32-I32-J32-K32
=L32+B33+C33+D33-F33-G33-H33-I33-J33-K33
=L33+B34+C34+D34-F34-G34-H34-I34-J34-K34
=L34+B35+C35+D35-F35-G35-H35-I35-J35-K35
=L34+B35+C35+D35-F35-G35-H35-I35-J35-K35
0 Comments
silahkan komentar jika berkenan