Tags：formula

How to Hide and Protect the Formulas You Used in Excel
As the work requires, you may send your Excel spreadsheet to other people at times. It means they can not only view the data, but also click any cell to check the formula it contains, or even modify it without your permission. To keep that from happening, you can try these steps to hide and […]

How to Insert Mathematical Formulas and Symbols in Word
When editing some documents involving mathematical formulas and symbols in Word, it can be a challenge to input them because you may not be able to find the corresponding buttons on keyboard. So what’s the best way to insert these relatively difficult formulas? Here are 3 commonly used methods you can try. Method 1. Insert […]

How to Calculate Ages from Birthdate Automatically in Excel
You may already know how to do simple calculations like summating and averaging in Excel. In fact, you can also use Excel formulas to solve some more practical problems. For example, if you’re registering the employees’ ages, but the only data you got are their birthdates, can you calculate their ages using Excel formula? The […]

How to Automatically Record the Data Entry Time in Excel
When making some financial or warehouse forms in Excel, we often need to record the time of entering different batches of data separately. And it can be very timeconsuming if we do it manually. So, is there a way to record the data entry time in Excel automatically? Like the answer to many other questions, […]

How to Calculate the Average Value of Data with Excel Function
Calculating the average value is a very common way to analyze data in Excel. To do the computations accurately and also rapidly, you can use Excel function to calculate mulitple, or even an entire column of data. Here’s the basic approach to use AVERAGE functin. 1. Select the E2 cell, Click Formulas – AutoSum – […]

How to Do Calculations with Power Function in Microsoft Excel
Other than addition, subtraction, multiplication and division, sometimes you may also need to calculate the third power or fifth power of the data in Excel spreadsheet. How will you do this kind of calculation? Using your calculator may be an answer, but not the best idea. If there are tons of data for you to […]

How to Create an Uninterrupted Sequence in Microsoft Excel
When inserting or deleting some rows to Excel spreadsheet, the sequence number will be interrupted and become incoherent, which could also affect your counting. In fact, you can use a very simple Excel formula to create an uninterrupted sequence in a column. 1. Enter the formula: =ROW()1 in the first cell of the sequence column. […]

How to Round Numbers Up or Down in Microsoft Excel
In the actual mathematical operations especiall financial calculations, you may often encounter the problem of rounding numbers. Although Excel allows you to define the decimal places in cells, the number itself is not really rounded. It could lead to some minor errors in financial operations. So is there any really easy way to round the […]

How to Calculate the Time Difference Quickly Using Excel Functions
In practice, we often need to calculate the difference of years, months, weeks or days between 2 separate dates. And like many other calculations, Excel functions can help you calculate the time difference quickly and accurately. Let’s see how to do it. Case 1: Calculate the Difference of Years Formula: =DATEDIF(A2,B2,”y”) A2, B2 corresponds to […]

How to Calculate the Absolute Value with ABS Function in Excel
Calculating the absolute value is very common in Excel data processing. To fulfil the task quickly and accurately, you don’t need to do the operations by your own. Just make use of ABS function, you can get the absolute values of a batch of data in seconds. 1. Create a new column to output the […]