Tecnologia, programação e muito Visual FoxPro.

quinta-feira, 30 de janeiro de 2020

Re: [SPAM] ]] XL-mania [[ Formula

 

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 wiranas.dalimunthe@pacificmedan.com [XL-mania] <XL-mania@yahoogroups.com> 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: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: Tuesday, January 28, 2020 3:26 PM
To: xl-mania; XL-mania@yahoogroups.com
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 raden.saputra@gmail.com [XL-mania] <xl-mania@yahoogroups.com> menulis:

 

 

 

 

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 nurul_kurnia05@yahoo.co.id [XL-mania] <XL-mania@yahoogroups.com> 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 <adi.idrus@bridgestone.com> menulis:

 

 

Ini maksudnya gimana ya bu? bisa diperjelas kah

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: Friday, January 24, 2020 10:35 AM
To: XL-mania@yahoogroups.com
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.

__._,_.___

Posted by: "Mr. Kid" <mr.nmkid@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www..mail-archive.com/xl-mania@yahoogroups.com

.

__,_._,___

Nenhum comentário:

Arquivo do blog