o… sudah jelas kalau begitu, trims mbak atas penjelasannya… From: [email protected] [mailto:[email protected]] On Behalf Of STDEV(i) Sent: Thursday, June 16, 2011 2:37 PM To: [email protected] Subject: Re: [belajar-excel] MENGUBAH FORMULA KE TEKS Kita sedang bicara tentang Makro Excel 4 Angka 6 berarti ingin menampilkan FORMULA dlm cell yg dirujuk argument GET CELL ada 60 lebih, (pernah ditayangkan di milis ini lengkap) ini siti pilihkan sebaign yg penting penting Proposed Name Arg # What =GET.CELL(Arg #,INDIRECT("RC[-1]",)) will return AbsReference 1 Absolute style reference like [Book1.xls]Sheet1!$A$1 ShowValue 5 Cell value ShowFormula 6 Cell formula NumFormat 7 Number format of cell IsLocked 14 True if cell is locked FormulaHidden 15 True if cell formula is hidden ShowWidth 16 Cell width. If array-entered into two cells of a row, second value is true if width is standard ShowHeight 17 Cell height WorkbookName 32 Workbook name like [Book1.xls]Sheet1 or Book1.xls if workbook and single sheet have identical names ShowFormulaWOT 41 Cell formula without translation into language of workspace HasNote 46 True if cell has a text note HasFormula 48 True if cell contains a formula IsArray 49 True if cell is part of an array formula IsStringConst 52 Text alignment char ' if cell is a string constant, empty string if not AsText 53 Cell displayed as text with numbers formatted and symbols included WorksheetName 62 Worksheet name like [Book1.xls]Sheet1 WorkbookName 66 Workbook name like Book1.xls 2011/6/16 Septi Yunita <[email protected]<mailto:[email protected]>> Dear belajar excel, Mau Tanya nech.. saya sedang baca-baca buku excel, ada bab tentang mengubah formula ke teks Missal : A1=1 A2=2 A3=3 Di A4=sum(A1:A3) Untuk mengubah formula di A4 menjadi teks dapat menggunakan define name yaitu : 1.insert>nama>define 2.isi name 3.isi refers to dengan : =GET.CELL(6,B4) Pertanyaan saya angka 6 diatas berarti apa ya?? Trims atas bantuan dan penjelasannya ##################################################################################### This email is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately. You should not copy or use it for any purpose, nor disclose its contents to any other person. #####################################################################################
<<inline: image001.jpg>>
<<inline: image002.jpg>>
