Working with Decimal Numbers

Working with a spreadsheet that requires decimal numbers can a little tricky at times especially if the user wants to manipulate or use the decimal numbers in its exact value.

There a number of ways to work with decimals, from the formatting like the number of decimal places the user wants to display on his spreadsheet, to the value of the number the user wants to consider for the decimal number, Round Up or Round Down.

Difference of Vlookup Function based on File Type

One of the most commonly used function in Excel is the Vlookup. It is considered as a function that a user must be familiar in order for the user to be considered as power user of Excel.

Only few users may have noticed, especially those power users, that there is a difference when using Vlookup function depending on the file type of the Excel file.

Logical Function: AND

This logical function is important when doing advanced work in Excel because it can help you control the behavior of your worksheets based on specific logical conditions.

The AND function will return true if all of its arguments are true. If one argument is false, the AND function will return false. For example, the logical statement 1<10 is true, and the statement 2>1 is also true. As a result, the compound statement 1<10 AND 2>1 is true, because both of the statements that are being joined by AND are true: