Frédéric LE GUEN

Author's posts

Excel could be a database with VLOOKUP

Purpose of the function VLOOKUP Often, Excel files contain data like customers, prospects or products. The VLOOKUP function returns the value of one cell of your reference table. To build a VLOOKUP, you needs 4 parameters First parameter of the function contains the value to search. Second parameter is the range of cells where of …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/use-excel-like-database-vlookup/

Functions AND – OR

Functions AND and OR are 2 logic functions that help you to create sophisticate logical tests. Presentation of the functions These functions are very useful with logical tests. Basically, with a logical test you compare 2 items only. But if you want to create a test with more items, you have to use these functions. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-and-or/

Function IF – Examples

The IF function is used to customize the result of a test. If the test returns TRUE, you can return a specific result, like “Win” and if the test is FALSE, you can display in the cell “Lost”. The IF function The IF function is build with 3 parameters The test The result if the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/if-function-excel/

Function SUM

This is the most commonly formula used and also the simplest to use. We will see in this page, different methods to perform a SUM in Excel. Presentation of the SUM function To perform a SUM function in Excel You simply start with the = sign in your cell Then, you enter the word SUM Then …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-sum/

3D Function

Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions. A 3D formula simplifies your writing Say you have a workbook that contains one sheet per month. You want to create a worksheet that will synthesize all these month in a worksheet …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/3d/