wkwkwk.... terus terang, saya kurang paham maksud kasusnya... jadi, ya saya diamkan saja... menunggu rekan lain yang me-reply untuk mempelajari maksud kasusnya lebih dulu... hahahaha...
On Thu, Jan 30, 2020 at 11:28 AM Wiranas Dalimunthe [email protected] [XL-mania] <[email protected]> wrote: > > > Dear master Mr Kid, > > > > Mau minta bantuannya bagaimana formula yang sama yang bisa diterapkan > dimasing-masing kolom agar > > pembagian nilai electircitynya mengikuti nilai pada kolom warna *Biru * > > > > Regards > > Wira > > > > *From:* [email protected] [mailto:[email protected] > <[email protected]>] > *Sent:* Tuesday, January 28, 2020 3:26 PM > *To:* xl-mania; [email protected] > *Cc:* Idrus, Adi > *Subject:* Re: [SPAM] ]] XL-mania [[ Menentukan Nilai Maximum > > > > *CAUTION*: This email originated from outside of the organization. Do not > click links or open attachments unless you recognize the sender and know > the content is safe. > > > > > > Terimakasih Kakak.... iya selama ini saya mengunkana manual dg IF sum, > akan tetapai IF sum hanya berlaku hingga header ke -11 saja. nah bagaimana > jika Headernya 30 an. > > Pada Selasa, 28 Januari 2020 14.44.08 WIB, Raden Saputra > [email protected] [XL-mania] <[email protected]> menulis: > > > > > > > > Dear [email protected], > > > > coba formula : > "=IF(SUM($D2:D2)>=95;"0,01";IF(SUM($D2:E2)>=95;"0,03";IF(SUM($D2:F2)>=95;"0,05";IF(SUM($D2:G2)>=95;"0,07";IF(SUM($D2:H2)>=95;"0,85";IF(SUM($D2:I2)>=95;"0,87";IF(SUM($D2:J2)>=95;"0,89";"")))))))" > > > > > > Regards > > > > Raden > > > > On Tue, Jan 28, 2020 at 10:36 AM [email protected] [XL-mania] < > [email protected]> wrote: > > > > Mohon maaf sebelumnya, karena infonya tidak detail, pada intinya saya > hendak mencari jumlah dari Header D1 Ke Header J1 yang jumlahnya minimal > >=95. > > Misalkan : > > ADI => sum (D2: J2) yang >= 95 , ternyata ada di Header 0.03 (E1) > > Pada Intinya mencari jumlah maximum >=95 ada di header mana. > > < div style="margin:10px 0px 0px 0.8ex;border-left:1px solid > rgb(204,204,204);"> > > Pada Jumat, 24 Januari 2020 15.05.51 WIB, Idrus, Adi < > [email protected]> menulis: > > > > > > Ini maksudnya gimana ya bu? bisa diperjelas kah > > > > *From:* [email protected] [mailto:[email protected]] > *Sent:* Friday, January 24, 2020 10:35 AM > *To:* [email protected] > *Subject:* [SPAM] ]] XL-mania [[ Menentukan Nilai Maximum [1 Attachment] > > > > > > Sahabat XL Mania, < /p> > > saya ada kendala mengenai penggunaan nilai maximum di XL, mohon di bantu > bagamana cara menetukan nilai Maximum, jika menggunakan IF(sum) akan ada > limited di kolom 11 > > *Error! Filename not specified.* > > > > terimakasih atas bantuannya > > > > -- > > Raden Saputra > > ------------------------------ > DISCLAIMER: This e-mail and any attachments to it are intended for the > named recipient(s) only. If you are not the named recipient, you should > notify the sender immediately, and delete this e-mail from your computer. > This e-mail may contain the private views and opinions of the sender and > does not constitute a formal view and/or opinion of PT. Pacific Medan > Industri, unless specifically stated. The contents of this e-mail and any > attachments may contain CONFIDENTIAL information. Any dissemination, > distribution or copying of CONFIDENTIAL information to other parties > without authorization from PT. Pacific Medan Industri is strictly > prohibited. PT. Pacific Medan Industri does not take any responsibility for > any damages caused by this e-mail from any virus or communication failure.. > ------------------------------ > > >
