If you want to make your own function tp calculate a bonus, etc, you can make with VBA. Now we learn ho to make a function with only one data source. 1. Open Excel 2. Open Developer | VBA / ALT + F11
3. Click Insert | Module 4. Type on module Function Name(Data) Example; Function Bonus(Jual) and press enter 5. Declare Variabel you want to use such komisi1, 2 , 3, dan 4 As Double 6. And give a value to Komisi1,2,3,dan 4. 7. Use Select Case to make a calculate bonus with condition total jual and don’t forget to type in the end “End Select” 8. Use Round to make Bonus show only 2 decimal 9.And back to Excel and save as Excel Add-In(xlam) and close excel 10. Open Excel and Click Office Button | Excel Option 11. Click Tab AddIn and Click Go 12. Click the function we make 13. Now you already can use the function to calculate the data you want just type =Bonus(cell/total jual), Next time will learn how to make a Function with 2 data Source. Download Tutorial -- Posting oleh mister.ahmad ke Tips and Trick pada 1/05/2010 01:43:00 AM -- You received this message because you are subscribed to the Google Groups "Gugukluhayat" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/gugukluhayat?hl=en.
