# 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
- 5 Best Anti Ransomware Software Free
- 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
- Scammed by Live PC Expert? 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?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?

## Most popular articles

- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- 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
- Scammed by Live PC Expert? 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?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?

**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.