Skip navigation Sign in. Being primarily designed as a spreadsheet program Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. Example LENA1 Cell A1 value is Shivam which has 6 Character length.
Below you will find 101 Excel formula functions examples for key formulas functions like VLOOKUP INDEX MATCH IF SUMPRODUCT AVERAGE SUBTOTAL OFFSET LOOKUP ROUND COUNT SUMIFS ARRAY FIND TEXT and many more.
This page contains many easy to follow IF examples. The Excel AND function is a logical function used to require more than one condition at the same time. Basic Excel Formulas Guide. For example cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.