Tuesday, January 22, 2019

DiViDe



This formula is to calculate per unit or per month salary . If you know the annual salary and want to know the per month salary then by applying this formula you can calculate it .
  • Below you can see a data related to the salary structure. In this data you have given annual salary of the employees and you can know the per month salary 


  • By applying formula =ANNUAL INCOME/MONTHS . Then press enter. In place of annual income and months you can have total cost of the product and per unit cost or any other data .

  • Now you can see your per month salary.


  • Now simply drag the column by putting cursor on it. And you get the per month salary of every employee. 




at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

FrEeZe PaNe

In a company or a school we have a number of students and employees and we maintain the data of all of them but sub times a hindrance ca...

  • SpLiT nAmE
    This formula is related to the separation of the first name and the last name in different cells. We generally write the name with its s...
  • MuLtIpLy
    The next formula is basically for calculating total amount of per unit price of the product  or salary of the employees per day etc  ...
  • mR. & mRs.
    When we have completed our data and submit that data to our authority and they say to add salutation MR. or MRS.   In front of the name...