How to Create a Formula in Excel

Creating a formula in Excel is one of the most fundamental skills you need to analyze, calculate, and manage data efficiently. Whether you’re using Windows, macOS, or Ubuntu, formulas allow you to perform mathematical operations, automate tasks, and make your spreadsheets dynamic and powerful. In this guide, you’ll learn exactly how to create a formula in Excel, along with the best shortcuts and methods tailored to your operating system.

💡 What Is a Formula in Excel?

A formula in Excel is an expression that calculates the value of a cell. It always starts with an equal sign = followed by the operation or function. For example:

=A1+B1 adds the values of cells A1 and B1.
=SUM(A1:A5) calculates the total of cells A1 through A5.
=AVERAGE(B1:B10) gives the average of a range.

Formulas can include:

Arithmetic operators: +, -, *, /
Cell references
Built-in functions (like SUM, IF, VLOOKUP)
Text manipulation, logical tests, and more

🪟 Creating a Formula in Excel on Windows

Click on a cell where you want the result
Type = to begin
Enter the formula (e.g., =B1+C1)
Press Enter

✅ Keyboard Shortcuts (Windows):

Insert Formula Quickly: Shift + F3 (opens the Insert Function dialog)
Display formulas in all cells: Ctrl + ~
AutoSum: Alt + =
Edit formula in the cell: F2

🍏 Creating a Formula in Excel on macOS

Select a cell
Type = to start
Add your formula (e.g., =A2*B2)
Press Return to apply

✅ Keyboard Shortcuts (macOS):

Insert Function: Shift + Fn + F3
Show formulas in all cells: Cmd + ~
AutoSum: Cmd + Shift + T
Edit formula in cell: Ctrl + U

🐧 Creating Formulas in LibreOffice Calc on Ubuntu

LibreOffice Calc, the open-source equivalent to Excel, works similarly.

Click a cell
Type = followed by the formula (e.g., =SUM(A1:A10))
Hit Enter

✅ Keyboard Shortcuts (Ubuntu / LibreOffice):

Insert Function Wizard: Ctrl + F2
Toggle formula view: Ctrl + ~
AutoSum: Ctrl + Shift + T
Edit cell content: F2

🧠 Common Excel Formula Examples

Formula Type	Example	Description
Addition	`=A1+B1`	Adds values in A1 and B1
Subtraction	`=C3-D3`	Subtracts D3 from C3
Multiplication	`=A2*B2`	Multiplies A2 and B2
Division	`=B4/A4`	Divides B4 by A4
Sum Function	`=SUM(A1:A5)`	Adds range A1 to A5
Average Function	`=AVERAGE(B1:B5)`	Finds average of B1 to B5
Logical IF	`=IF(A1>10, "Yes", "No")`	Returns Yes if A1 > 10, else No

🔍 Troubleshooting Formulas

#DIV/0! – Division by zero
#NAME? – Misspelled function or range
#REF! – Invalid cell reference
#VALUE! – Wrong data type used in formula

Use F2 (Windows/Linux) or Ctrl + U (macOS) to check formulas.

✨ Best Practices for Formulas

Always start with =
Use absolute references ($A$1) for fixed values
Combine text with & operator (e.g., ="Hello "&A1)
Use named ranges for clarity
Document complex formulas with comments or notes

❓ FAQ – Excel Formulas

Can I drag formulas to apply them to multiple cells?
Yes! Use the fill handle (small square at the bottom-right of the cell).

What’s the difference between relative and absolute references?
Relative (A1) changes when copied; absolute ($A$1) stays fixed.

Can I use formulas across worksheets?
Yes. Reference another sheet like: =Sheet2!A1 + Sheet1!B2.

Do formulas work the same in Google Sheets and LibreOffice?
Mostly, yes. Some functions might have slight differences.

✅ Conclusion

Now that you know how to create a formula in Excel, you can start building smarter spreadsheets with confidence. Whether you’re on Windows, macOS, or Ubuntu, Excel and its alternatives offer flexible ways to calculate, automate, and visualize data. Use the shortcuts and techniques above to speed up your workflow and make your spreadsheets truly dynamic.

Complete List of Windows Keyboard Shortcuts

If you need help for Windows, you can find a whole list of all keyboard shortcuts here.

https://keyboard-shortcuts.org/

Advertisment