Sunday, January 20, 2019

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 

  • We have a data related to the computer parts , their quantity ,and price per unit  



  • By applying formula  = QUANTITY*PER PIECE  . Then press ENTER . In place of quantity and per piece you can have some other data like no. Of days and per day
             


  • Now you get your total amount 



  • You need not to apply this formula again and again . Just simply drag the cell by putting the cursor on it ..
                      






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...