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 <herry...@yahoo.com> wrote: > Hallo Mamat Didi, > Berikut penjelasannya kenapa beda! > SIN function > Show 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 <mamatd...@gmail.com> > *To:* belajar-excel@yahoogroups.com > *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.. >