Iya nih .... kayaknya slah ...... maaf ..... maaf .... lagi binun .....salah kamar nih .....
From: STDEV(i) <[email protected]> To: [email protected] Sent: Wednesday, May 18, 2011 10:43 AM Subject: Re: [belajar-excel] Menentukan Nama Petak berdasarkan No urut Petak moho9n maaf, moderator binun ' ! ini memenggapi topi apa ya 'tanya napa petak berdasarkan nomor petak' dijawab "Sinus Cosinus Tangen" On Wed, May 18, 2011 at 10:32 AM, Herry Sutjipto <[email protected]> wrote: Hallo Mamat Didi, >Berikut penjelasannya kenapa beda! >SIN functionShow All >Hide All >This article describes the formula syntax and usage of the SIN >function (function: A prewritten formula that takes a value or values, >performs an operation, and returns a value or values. Use functions to >simplify and shorten formulas on a worksheet, especially those that perform >lengthy or complex calculations.) in Microsoft Excel. > >Description > >Returns the sine of the given angle. > >Syntax > >SIN(number) > >The SIN function syntax has the following arguments (argument: A value that >provides information to an action, an event, a method, a property, a function, >or a procedure.): > >Number Required. The angle in radians for which you want the sine. > >Remark > >If your argument is in degrees, multiply it by PI()/180 or use the RADIANS >function to convert it to radians. > >Example > >The example may be easier to understand if you copy it to a blank worksheet. > >How do I copy an example? > >Select the example in this article. >Important Do not select the row or column headers. >Selecting an example from Help >Press CTRL+C. >In Excel, create a blank workbook or worksheet. >In the worksheet, select cell A1, and press CTRL+V. >Important For the example to work properly, you must paste it into cell A1 of >the worksheet. >To switch between viewing the results and viewing the formulas that return the >results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula >Auditing group, click the Show Formulas button. > >After you copy the example to a blank worksheet, you can adapt it to suit your >needs. > >1 >2 >3 >4 >5 >A B >Formula Description (Result) >=SIN(PI()) Sine of pi radians (0, approximately) >=SIN(PI()/2) Sine of pi/2 radians (1) >=SIN(30*PI()/180) Sine of 30 degrees (0.5) >=SIN(RADIANS(30)) >Sine of 30 degrees (0.5) > > > >From: Mamat Didi <[email protected]> >To: [email protected] >Sent: Tuesday, May 17, 2011 4:02 PM >Subject: [belajar-excel] Menentukan Nama Petak berdasarkan No urut Petak > > > > >Yth. Para Excel Masters > >Saya punya kesulitan bagaimana caranya menampilkan Nama Pemilik Petak >berdasarkan no urut petak dari daftar pemilik sawah sebagaimana file >terlampir. >Mohon dengan sangat..mohon dengan sangat..mohon dengan >sangat..bantuannya, otak tua saya kayaknya sudah nggak "ngatasi" >he..he.. >

