Tags：function

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 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 Generate Dummy Text in Word Document
Before writing in Word, you may be used to set the format and page layout at first. But without an ensemble preview, you can hardly know how it looks like in the actual document. In fact, you can generate some random dummy text in Word with random functions to check the typesetting effect. 1. Generate […]

5 Cases to Use Microsoft Excel IF Function in Practice
IF function, also known as conditional function, enables you to get corresponding results in Microsoft Excel spreadsheets when meeting the specific conditions. How Does IF Function Work The function syntax of IF function is: IF(logical_test,[value_if_true],[value_if_false]). If the specified conditions evaluate to true, this function will return a value; If the specified conditions evaluate to false, […]

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data
VLOOKUP is a very useful Excel function which can easily search through a column and find the corresponding data. For example, you can search for the score of a student in class quickly according to his or her name. The basic formula for VLOOKUP is: =VLOOKUP (lookup_value,table_array,col_index_num,range_lookup) “lookup_value” refers to the keyword for searching; “table_array” […]

How to Insert a Random Number in Excel
Random numbers are quite useful in many situations of life and work. And it’s very simple to generate them with Excel function. Here’s the method. 1. Open the Excel file, click a cell and type the formula in it. If you want to generate a number in the range of 1100, then input “=RANDBETWEEN(1,100)” . […]