[belajar-excel] Digest Number 1605

Milis Belajar Microsoft Excel

Messages In This Digest (4 Messages)

1a.

Menambah IF dalam formula From: Mansor

1b.

Re: Menambah IF dalam formula From: M. Ferdiansyah

1c.

Bls: [belajar-excel] Menambah IF dalam formula From: supri yadi

2.

WINDOW BARU TIDAK MUNCUL From: Kurei recca

View All Topics | Create New Topic

Messages

1a.

Menambah IF dalam formula

Posted by: "Mansor" dbpermatasari@gmail.com   nbmy1980

Sun May 6, 2012 6:48 pm (PDT)

Teman BeExcel,

Saya mau nambah satu lagi kondisi dalam rumus yang sudah ada.

Rumus sekarang;

(1) Jika B2="Vendor" outputnya "2"

(2) Jika B2="Customer" outputnya "4"

(3) Jika B2 = "GL" dan C2<=100, outputnya "1"

Selain dari itu outputnya "3"

Sekarang saya diminta menambah kondisi bagi GL.

(4) Jika B2 ="GL" dan C2>100 dan LEFT(B2)="6", outputnya "1"

Selain dari itu "3"

Terima kasih.

-Mansor

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

1b.

Re: Menambah IF dalam formula

Posted by: "M. Ferdiansyah" muh_ferdy@pusri.co.id   muh_f3rdi4n5yah

Sun May 6, 2012 7:30 pm (PDT)

Dear pak mansor,

rumus awal :
=IF(B2="Vendor","2",IF(B2="Customer","4",IF(AND(C2<=100,B2="GL"),"1","3")))

Oh iy, poin (4) Jika B2 ="GL" dan C2>100 dan LEFT(B2)="6", outputnya "1",
benar itu pak LEFT(B2) = "6" atau LEFT(A2) = "6"?

kl, LEFT(A2)="6" bagaimana kl diedit menjadi begini :
=IF(B2="Vendor",2,IF(B2="Customer",4,IF(OR(AND(C2<=100,B2="GL"),AND(B2="GL",C2>100,--LEFT(A2)=6)),1,3)))

regard ferdy..

> Teman BeExcel,
>
> Saya mau nambah satu lagi kondisi dalam rumus yang sudah ada.
>
> Rumus sekarang;
>
> (1) Jika B2="Vendor" outputnya "2"
>
> (2) Jika B2="Customer" outputnya "4"
>
> (3) Jika B2 = "GL" dan C2<=100, outputnya "1"
>
> Selain dari itu outputnya "3"
>
>
>
> Sekarang saya diminta menambah kondisi bagi GL.
>
> (4) Jika B2 ="GL" dan C2>100 dan LEFT(B2)="6", outputnya "1"
>
>
>
> Selain dari itu "3"
>
> Terima kasih.
>
> -Mansor
>

____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

1c.

Bls: [belajar-excel] Menambah IF dalam formula

Posted by: "supri yadi" supriyadi_sbm@yahoo.co.id   supriyadi_sbm

Sun May 6, 2012 7:37 pm (PDT)

Dear pak Mansor,

Jika maksud bapak adalah jika LEFT(A2)=6 atau LEFT(A2)<>6.
Bisa dicoba rumus ini atau langsung download attachment.

=IF(AND(LEFT(A2)<>6,B2="Vendor"),"2",IF(AND(LEFT(A2)<>6,B2="Customer"),"4",IF(AND(LEFT(A2)<>6,B2="GL",C2<=100),"1",IF(AND(B2="GL",C2>100,LEFT(A2)="6"),"1","3"))))

Best Regards,
Supriyadi
Maintenance belt conveyor

________________________________
Dari: Mansor <dbpermatasari@gmail.com>
Kepada: belajar-excel <belajar-excel@yahoogroups.com>
Dikirim: Senin, 7 Mei 2012 8:41
Judul: [belajar-excel] Menambah IF dalam formula


 
 
 
 
Teman BeExcel,
Saya mau nambah satu lagi kondisi dalam rumus yang sudah ada.
Rumus sekarang;
(1)    Jika B2="Vendor"outputnya "2"
(2)    Jika B2="Customer"outputnya "4"
(3)    Jika B2 = "GL" dan C2<=100, outputnya "1"
         Selain dari itu outputnya "3"
 
Sekarang saya diminta menambah kondisi bagi GL.
(4)     Jika B2 ="GL" dan C2>100 dan LEFT(B2)="6", outputnya "1"
      
   Selain dari itu "3"
Terima kasih.
-Mansor
 
 

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2.

WINDOW BARU TIDAK MUNCUL

Posted by: "Kurei recca" yusajing_ehm@yahoo.com   yusajing_ehm

Sun May 6, 2012 8:52 pm (PDT)

Salam Para Master Excel,

Saya Ingin bertanya, tidak tau kenapa excel saya tidak bisa dibuka menjadi > 1 window yang ada,
Semua berada di dalam 1 window,,
Bagaimana agar tampil seperti normal kembali ? yaitu ketika saya buka 2 Workbook maka ada 2 window yang terbuka
Mohon Pencerahannya
Best regards

Lebih jelasnya seperti gambar di bawah ini :

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

Recent Activity

•  11
  New Members

Visit Your Group

Y! Groups blog

The place to go

to stay informed

on Groups news!

Yahoo! Groups

Small Business Group

Own a business?

Connect with others.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages

---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke:
belajar-excel@yahoogroups.com

berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran
http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe