Excel Formula cheat sheet

Utilizing Excel spreadsheets regularly has helped me keep up with shortcuts with all the amazing and helpful functions. Today i will be sharing some of the formula functions so you can use on your next spreadsheet adventure.

SUM: The SUM function will add up numbers in a range of cells.

• Syntax: =SUM(number1, [number2], ...)
• Example: =SUM(A1:A10)

CONCATENATE: Combines text from two or more cells into one cell.

• Syntax: =CONCATENATE(text1, [text2], ...)
• Example: =CONCATENATE(A2, " ", B2)

IF :Returns one value if a condition is true and another value if it's false.

• Syntax: =IF(logical_test, value_if_true, [value_if_false])
• Example: =IF(B2>10, "Yes", "No")

DATEDIF : Calculates the difference between two dates in various date units (days, months, years).

• Syntax: =DATEDIF(start_date, end_date, unit)
• Example: =DATEDIF(A2, B2, "d") for days, "m" for months, "y" for years.

These formulas cover a large range of functions from simple to complex data analysis and lookup functions. Mastering these formulas can significantly enhance your ability to maneuver and analyze data efficiently in Excel.