Financial Functions Logical Functions Text Date & Time Lookup & References Math & Trig
And more functions.
Insert and Use Functions for our Data
Here in the library of function we have lots of functions that often we use them in our office or worksheets. But, here our first option let us search and insert function directly from the library. To do that just click Insert Function. In the new window you can type a brief description of what you want to do then click go, then you can find the function that wanted or the function which is similar to your function. Here to find easily the function select the category then search.
Use Function and Calculate your Days
In this step, I am going to make an example and use the function to show that how they can be used. Here I have a table of some electronic devices which I bought them. I wrote the quantity of each device and the price per device. Then I wrote the total prices, as you see there is also the Ordered date and Received date of devices. But the function which I want to use that is used to calculate the total days between the ordered date and received date. I want to know that how long I received the devices. Now click on the cell below the total days, and go to Function Library. Then click on the Date & Time option to find your function. Here you want to calculate the days that you had waited for devices, then you need to select DAYS. Here click on this function and open the new window. On the new window you have two cells, in the first cell select the End date and in the second cell select the start date. then directly on that window, you can see that how many days you have waited for the devices. Then click OK to get the result on the cell.
Now we got the result and we can easily apply this function on all of them. Here also we can use the function sum to calculate the total days of every device. Just click on the cell and find the function from the library. Here it works directly just select the bottom cell and click on AutoSum function then click Enter.
Conclusion
Functions are the best way to calculate your data in your worksheets and it has done your task easy and quickly. Here we have different functions for different worksheets just find and use them. Thanks for being with us.
