Tags：function

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 dummy text in Word with random functions to check the typesetting effect. 1. Generate Sample […]

5 Cases to Use MS 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)” . […]