Terimakasih pak Maman atas solusinya.. Sangat membantu sekali..
> dengan memakai fungsi DEGREES(ASIN(0.5)) pa..apabila ingin di balikin lagi > ke > satuan derajatnya > > > > > > ________________________________ > Dari: M. Ferdiansyah <muh_fe...@pusri.co.id> > Kepada: belajar-excel@yahoogroups.com > Terkirim: Rab, 18 Mei, 2011 14:44:48 > Judul: [belajar-excel] [Invers] Sin Cos Tan dalam excel > > > Terimakasih untuk Bpk.Maman & Bpk.Zainul atas jawabannya.. > > Karena saya tidak pernah menggunakan satuan sudut dalam excel jadi saya > tidak begitu mengerti.. > > Tetapi bagaimana dengan Invers Sin ? > Misal : > =Sin(Radians(30)) = 0.5 > 0.5 = Sin brp ? > > Mohon bantuannya.. > > regard, > Ferdy > >> Secara default, satuan sudut dalam excel adalah radian. >> >> Agar hasilnya sama dengan calculator yang bersatuan derajat, sudut nya >> harus >> diconvert menjadi derajat. >> >> >> >> Missal [B5] adalah sudut dalam satuan derajat, Maka untuk mencari sin, >> >> =SIN(RADIANS(B5))=0.5 >> >> >> >> Jika berkenan mampir, saya membuat catatan sederhana tentang konversi >> sudut >> di >> >> http://cadex.wordpress.com/2010/02/27/xls-svy-02-catatan-rumus-excel-untuk-j >> uru-ukur-bagian-1/ >> >> >> >> From: belajar-excel@yahoogroups.com >> [mailto:belajar-excel@yahoogroups.com] >> On Behalf Of M. Ferdiansyah >> Sent: Wednesday, May 18, 2011 10:09 AM >> To: belajar-excel@yahoogroups.com >> Subject: [belajar-excel] Sin Cos Tan dalam excel >> >> >> >> >> >> Selamat pagi rekan-rekan b-excel, >> >> Langsung aja ke sumber masalahnya ya.. >> Saya ada kendala dalam perumusan dengan menggunakan rumus "Sin Cos >> Tan".. >> Kenapa hasil dari excel dengan kalkulator / tabel derajat beda ya?? >> >> Mohon tanggapannya.. >> >> Sekian dan terimakasih.. >> regard, >> >> Ferdy >> >> ____________ _________ _________ _________ _________ _________ _________ >> Notice : This e-mail (and any attachment) is strictly confidential and >> is intended only for the addressee(s)above. Is strictly prohibited to >> forward, print, copy, or otherwise reproduce this message that would >> allow it to be viewed by any individual not originally listed as >> a recipient(s). If you have received this e-mail in error, please >> immediately notify the sender and delete this message. The opinions >> expressed in this e-mail (and any attachment) are those of the >> individual >> sender and may not necessarily reflect the views of PT Pusri. >> ____________ _________ _________ _________ _________ _________ _________ >> >> >> >> > > ____________ _________ _________ _________ _________ _________ _________ > Notice : This e-mail (and any attachment) is strictly confidential and > is intended only for the addressee(s)above. Is strictly prohibited to > forward, print, copy, or otherwise reproduce this message that would > allow it to be viewed by any individual not originally listed as > a recipient(s). If you have received this e-mail in error, please > immediately notify the sender and delete this message. The opinions > expressed in this e-mail (and any attachment) are those of the individual > sender and may not necessarily reflect the views of PT Pusri. > ____________ _________ _________ _________ _________ _________ _________ > > > ____________ _________ _________ _________ _________ _________ _________ Notice : This e-mail (and any attachment) is strictly confidential and is intended only for the addressee(s)above. Is strictly prohibited to forward, print, copy, or otherwise reproduce this message that would allow it to be viewed by any individual not originally listed as a recipient(s). If you have received this e-mail in error, please immediately notify the sender and delete this message. The opinions expressed in this e-mail (and any attachment) are those of the individual sender and may not necessarily reflect the views of PT Pusri. ____________ _________ _________ _________ _________ _________ _________
