# Enter Formulas in a Cell: MS Excel

You can type formulas in a cell to do all sorts of calculations.

Formulas always begin with an equal sign (=). Then, to calculate the result, they combine numbers, cell references, and these arithmetic operators:

- + to add

- - to subtract

- * to multiply

- / to divide

- % to take a percent

- ^ to raise to a power (or exponent)

- ( ) to change the order of calculation

Excel calculates formulas from left to right, following a set order of operations. Enclosing part of a formula in parentheses changes the order in which the items are calculated. Look at this example:

=(48 12)*2/9 +1

This formula equals 9 because the calculations inside the parentheses happen first multiplication and division next, and then addition and subtraction.

=(48 12)*2/(9 +1)

The added parenthesis makes this formula yield 7.2, since both the subtraction and addition operations inside the parentheses are executed before the normal order of operations.

Creating formulas is the most common skill used in building worksheets.

Visit Carol's web site to learn more tips like this one!

## Most popular articles

- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10

## Most popular articles

- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10

**Do you need Tech Support?**

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.