Creating,your,own,functions,Ex DIY Creating your own functions in Excel
When starting a new work at home business it is very easy to become consumed by it. We spend so much time trying to get the business up and running that we may end up becoming burned out and lose our motivation. There is so much to learn and Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-parent:"";mso-padding-alt:0in
Today morning it was raining cats and dogs. My good old walking friend called me up and insisted that we must not miss our walk. But I reminded him that it was raining and how! He just would not give up and I gave in. I hate to say 'no' to my friends. Also, I thought: let's have some fun in the rain because everybody at home was sleeping anyway. I reached the forest at around 5:45 a. m. And surprise of surprises! All the friends were there. They were all grinning like jackals. I became alert. Now what? What were these guys planning? Now one of them says: You know that guy claims that you can't create your own functions to calculate in Excel. So that's it! Well, that's what good friends are for, isn't it? I explained in detail that you can create a custom function using macros in Microsoft Excel. They almost fainted. Macros! No, they were not interested in programming. So, I promised to send them a 'steamy' video. My friend called up to say that it was a dry steamy video. Nonetheless, he enjoyed it and that he owed me a coffee with the sinful brownie at Cafe Coffee Day! Here's the custom function I wrote and you can view the video on my website. You start the Visual Basic Editor and enter the following code: Function paypackage(salary) 'House Rent Allowance (HRA) 'HRA=60% of basic salary,br> 'Leave Travel Allowance (LTA) 'LTA=8.33% of basic salary paypackage = salary + salary * 0.6 + salary * 0.0833 End FunctionThis function automatically calculates the paypackage of an employee based on the basic salary that you assign this Employee.
Creating,your,own,functions,Ex