# 50 Excel Functions You Need to Know

Microsoft Excel is one of the most complete office automation software. It allows you to create complex spreadsheets and supports many functions. To perform certain actions, you have to go through quite complicated formulas. The Excel functions presented here are all available within Microsoft Excel 2010 in French. Very few differences exist with the other versions of the software, but you will have to translate these functions if you use Excel in English or in another language. If you use other functions on a daily basis, do not hesitate to present them in the comments! To go further, you can also train yourself to become an Excel expert . Mathematics and trigonometry RAND BETWEEN TERMINALS – In Excel, to get a random integer between two specified bounds. Example: RANDBETWEEN(1;42) returns a random number between 1 and 42. ROUND – Allows you to round a number, according to the number of digits after the specified comma.

## Mathematics and Trigonometry

You can use another parameter instead of 2 to calculate . Allows you to test a condition and return a certain value if it is true, another if it is false. Example: IF(average(A1:A15) “I have the average”; “I don’t have the average”) allows to know if we have the average, when the scores are between cells A1 and A15. Research and matrices COLUMN – Gets the column number. Example: COLUMN(A42) returns Canada Business Fax List the value 1 because column A is the first column. Variant: COLUMN() returns the value corresponding to the column where the Excel formula is located. SEARCH – In some cases, search formulas can save lives. Example: SEARCH(42;A:A;B:B) will look for the value 42 in column A, then transcribe its equivalent in column B (on the same line). SEARCH can also be used to search in a matrix or a vector.