Dear Pak Odong Nando,

Super sekali jadi simple formulanya, terima kasih banyak dan bisa berjalan di 
laptop saya.

Terima kasih
Samsudin

From: [email protected] [mailto:[email protected]]
Sent: Saturday, November 21, 2015 4:25 PM
To: [email protected]
Subject: Bls: [belajar-excel] Kapasitas AC


yoo samsudin,
mungkin dengan sedikit perubahan tabel refrensi menjadi

BTU/h

Kapasitas

               60.000

4 PK

               32.000

3 1/2 PK

               30.000

3 PK

               20.000

2 1/2 PK

               18.000

2 PK

                 9.000

1 1/2 PK

                 7.000

1 PK

                 5.000

1/2 PK


dan masukan formula :
=LOOKUP( 2 ; 1 / ( C 16 : C 23 > = G 2 0 ) ; D 1 6 : D 2 3 )

pada H22, silahkan di coba

ganti karakter titik koma ";" menajdi koma "," bila regional setempet english

br,

odong nando


Pada Sabtu, 21 November 2015 6 :18, "Samsudin 
[email protected]<mailto:[email protected]> [belajar-excel]" 
<[email protected]<mailto:[email protected]>> menulis:


Dear Master Excel,

Saya ingin membuat template tentang kapasitas AC (file terlampir), mohon 
bantuannya untuk bisa memberikan template tersebut lebih informative dan yang 
ingin diubah adalah pada cell H22, dimana disitu saya menggunakan formula if 
standar, apakah ada formula yang lebih simple? :


Terima kasih atas bantuannya.

Terima kasih
Samsudin


---------------------------------------------------------------------------------------------------





This message (including any attachments) contains confidential information 
intended

for a specific individual and purpose, and is protected by law. If you are not 
the

intended recipient, you should delete this message and hereby notified that any

disclosure, copying, or distribution of this message (or any part thereof), or 
the

taking of any action based on it, is strictly prohibited. No liability or 
responsibility

is accepted if information or data is, for whatever reason corrupted or does 
not reach

its intended recipient. No warranty is given that this email is free of 
viruses. The

views expressed in this email are, unless otherwise stated, those of the author 
and

not those of the Company or its management. The Company reserves the right to 
monitor,

intercept and block emails addressed to its users or take any other action in 
accordance

with its email use policy.




---------------------------------------------------------------------------------------------------

This message (including any attachments) contains confidential information 
intended
for a specific individual and purpose, and is protected by law. If you are not 
the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or 
the
taking of any action based on it, is strictly prohibited. No liability or 
responsibility
is accepted if information or data is, for whatever reason corrupted or does 
not reach
its intended recipient. No warranty is given that this email is free of 
viruses. The
views expressed in this email are, unless otherwise stated, those of the author 
and
not those of the Company or its management. The Company reserves the right to 
monitor,
intercept and block emails addressed to its users or take any other action in 
accordance
with its email use policy.

Kirim email ke