Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following …
ROUND function - Microsoft Support
To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for …
Round a number to the decimal places I want - Microsoft Support
Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or …
VLOOKUP function - Microsoft Support
Use the VLOOKUP function to look up a value in a table. There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also …
Correct a #NULL! error - Microsoft Support
If you get this error because you’ve used a space character between ranges that don’t intersect, change the references so that ranges do intersect. For example, in the formula =CELL …
RAND function - Microsoft Support
This article describes the formula syntax and usage of the RAND function in Microsoft Excel. RAND returns an evenly distributed random real number greater than or equal to 0 and less …
PRICEMAT function - Microsoft Support
This article describes the formula syntax and usage of the PRICEMAT function in Microsoft Excel. Returns the price per $100 face value of a security that pays interest at maturity. PRICEMAT …
"This product key has already been used" error in Office
If you see the message "This product key has already been used," this means that you've already redeemed your product key and added your Office product to your Microsoft account. Don't …