Skip to content
Solve Your Tech
Menu

Formulas

How-to guides and tutorials about topics related to formulas that you use in the spreadsheets on your computer or phone.

Solve Your Tech

How to Use Excel to Find Percentiles: A Step-by-Step Guide

January 9, 2024 by Matthew Burleigh

Calculating percentiles in Excel is a breeze. Simply use the PERCENTILE or PERCENTILE.EXC function, input your data range and the percentile you’re looking for, and …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
Solve Your Tech

How to Make a Profit Margin Formula in Excel: A Step-by-Step Guide

January 9, 2024 by Matthew Burleigh

Making a profit margin formula in Excel requires setting up a spreadsheet with your cost and revenue data, then creating a formula that divides net …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
Solve Your Tech

How to Deduct a Percentage in Excel: A Step-by-Step Guide

January 9, 2024 by Matthew Burleigh

Deducting a percentage in Excel is a breeze once you get the hang of it. Simply click on the cell you want to calculate the …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
Solve Your Tech

How to Calculate Gross and Net Margins in Excel: A Step-by-Step Guide

January 9, 2024 by Matthew Burleigh

Calculating gross and net margins in Excel is a straightforward process that involves a few simple formulas. Once you input your revenue and cost data, …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
Solve Your Tech

How to Use the Less Than or Equal to Function in Excel: A Step-by-Step Guide

January 9, 2024 by Matthew Burleigh

To use the less than or equal to function in Excel, you simply need to type the formula <= followed by the value you are …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
Solve Your Tech

Excel Formula to Find Differences in Numbers: A Step-by-Step Guide

January 9, 2024 by Matthew Burleigh

Excel is a powerful tool that can do a lot more than just addition and subtraction. Have you ever needed to find differences between numbers …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
how to remove the first character from a cell in excel 2013

How to Remove First Character in Excel 2013 Cell

December 18, 2023 by Matthew Burleigh

Microsoft Excel includes a lot of tools that can help you quickly manage your data. Some of these are things that you might be using …

Read More

Categories Programs Tags Featured Excel, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
Solve Your Tech

How to Apply a Formula to an Entire Column in Google Sheets

December 13, 2023 by Matthew Burleigh

Learning how to apply a formula to an entire column in Google Sheets is a simple task that can save you time and headaches. Just …

Read More

Categories Web Browsers and Applications Tags Formulas, Google Sheets How-To Guides
how to count the number of characters in a cell in Excel 2013

How to Use the Character Count Excel 2013 Tool

August 4, 2023November 28, 2022 by Matthew Burleigh

If you’ve ever tried to count the number of digits or letters in a cell, then you have probably discovered that it’s kind of difficult. …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to calculate percentage in excel 2013

How to Calculate Percentage in Excel

June 30, 2023November 25, 2022 by Matthew Burleigh

Microsoft Excel has a lot of different ways that you can compare data. Many of these options exist as formulas, and it’s likely that you …

Read More

Categories Programs Tags Featured Excel, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
How to Subtract in Google Sheets

How to Subtract in Google Sheets

July 18, 2023November 8, 2022 by Matthew Burleigh

Spreadsheet applications like Microsoft Excel and Google Sheets are more than just a way to organize and display data. They are also powerful applications capable …

Read More

Categories Web Browsers and Applications Tags Featured Sheets, Formulas, Google Sheets How-To Guides
disable formula updates in excel 2010

How to Turn Off Formulas in Excel 2010

July 1, 2023November 8, 2022 by Matthew Burleigh

Microsoft Excel formulas are amazing for their ability to quickly perform complex calculations and provide you with an answer. While it can seem like these …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
type the subtraction formula into the cell

How to Subtract in Excel 2013 with a Formula (An Easy 4 Step Guide)

June 29, 2023November 8, 2022 by Matthew Burleigh

There is a pretty steep learning curve when you start to see all of the different things that you can do in Microsoft Excel. It’s …

Read More

Categories Programs Tags Featured Excel, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to turn on iterative calculations in google sheets

How to Enable Iterative Calculation in Google Sheets

July 19, 2023November 8, 2022 by Matthew Burleigh

Many people that use Google Sheets won’t encounter problems with the settings that it has in the default configuration. But if your spreadsheet contains a …

Read More

Categories Web Browsers and Applications Tags Formulas, Google Sheets How-To Guides
how to combine three columns into one in Excel 2013

How to Combine Three Columns Into One in Excel

July 28, 2023October 28, 2022 by Matthew Burleigh

It’s often a good idea to separate as much information as possible in Microsoft Excel. Depending on what you are going to be using that …

Read More

Categories Programs Tags Columns, Concatenate, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to display a zero instead of #n/a in excel 2013 vlookup formula

How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013

July 1, 2023August 12, 2022 by Matthew Burleigh

The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. Along with the concatenate formula, I have …

Read More

Categories Programs Tags Formulas, Microsoft, Microsoft Excel 2013, Microsoft Excel How-To Guides
view the median formula

How to Calculate Median in Excel 2013

July 18, 2023March 16, 2022 by Matthew Burleigh

Learning how to calculate a median in Excel 2013 is similar to learning how to perform most other mathematical functions within the program, such as …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
formula bar is displayed

How to Unhide Formula Bar in Excel 2010

July 27, 2023December 14, 2021 by Matthew Burleigh

Knowing exactly what you are working on is critical in Microsoft Excel, especially when you are adjusting a formula. One way to make this a …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
trim a digit from a number in excel 2013

How to Remove Last Digit in Excel 2013

August 10, 2023November 30, 2021 by Matthew Burleigh

The Microsoft Office spreadsheet application, Microsoft Excel, offers a lot of ways that you can manipulate the values within the cells of your spreadsheets. For …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to find the sum of a row in Excel 2010

How to Find a Row Sum in Excel 2010

July 31, 2023November 8, 2021 by Matthew Burleigh

If you haven’t used the formulas that Microsoft Excel provides, then you may not realize just how powerful the application can be. While its formatting …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
how to print formulas in Excel 2010

How to Print Formulas in Excel 2010

June 23, 2023October 24, 2021 by Matthew Burleigh

Configuring the data in the cells of your Microsoft Excel spreadsheet is often just one part of creating and distributing data. While a spreadsheet may …

Read More

Categories Programs Tags Formulas, Microsoft Excel How-To Guides
enter the convert formula

How to Convert MM to Inches in Excel 2013

July 9, 2023March 18, 2021 by Matthew Burleigh

Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Fortunately if you want to convert …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
formula bar showing average

How to Find an Average in Excel 2013

June 21, 2023March 15, 2021 by Matthew Burleigh

Microsoft Excel includes a number of different ways that you can calculate totals or values based on your cell data. But if you need to …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
How to Change Recalculation Settings in Google Sheets

How to Change Recalculation Settings in Google Sheets

August 1, 2023February 7, 2019 by Matthew Burleigh

When you make a change in one of your Google Sheets spreadsheets, certain functions will recalculate so that you always have the most current information. …

Read More

Categories Web Browsers and Applications Tags Formulas, Google Sheets How-To Guides
how to calculate age in excel 2013

How to Calculate Age from a Birthdate in Excel 2013

July 24, 2023August 21, 2018 by Matthew Burleigh

Excel has a lot of tools that can help you calculate values based on data that you’ve entered. You’ve probably had to add up values …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to show formulas in google sheets

How to Show Formulas in Google Sheets

June 18, 2023September 1, 2017 by Matthew Burleigh

The beauty of formulas in spreadsheets is their ability to perform calculations for you. Often this occurs with the help of a mathematical operator in …

Read More

Categories Web Browsers and Applications Tags Formulas, Google Sheets How-To Guides
how to concatenate text in excel 2013

How to Concatenate Text in Excel 2013

May 30, 2023June 6, 2017 by Matthew Burleigh

Retyping data is always a hassle in spreadsheets. It’s also prone to errors, so you might be looking for a better way to combine data …

Read More

Categories Programs Tags Concatenate, Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to add leading zeroes in excel 2013

How to Add Leading Zeroes to Numbers in Excel 2013

June 20, 2023January 26, 2017 by Matthew Burleigh

If you are working with numbers that might include zeroes at the start of those numbers, then you might be running into a problem. Excel …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to find the number of workdays between two dates in excel

How to Calculate the Number of Workdays Between Two Dates in Excel 2013

July 12, 2023January 12, 2017 by Matthew Burleigh

One way that you can use Excel 2013 is to keep track of ongoing projects, or important dates that occur either in your personal life …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
multiplying cell values and numbers in Excel 2013

How to Multiply in Excel 2013

July 27, 2023July 21, 2016 by Matthew Burleigh

If you are trying to figure out how to multiply in Excel 2013, then you might be struggling to find the formula or option to …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
why an excel sum is not updating

Why Isn’t My Sum Updating in Excel 2013 Anymore?

July 31, 2023June 22, 2016 by Matthew Burleigh

A sum that is not updating automatically in Excel 2013 can be frustrating and, depending upon the importance of the information that it affects, potentially …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
excel formulas not working

Excel 2013 Formulas Not Working

July 17, 2023May 31, 2016 by Matthew Burleigh

It can be frustrating, even problematic, when your Excel formulas are not working. We use formulas in our Excel spreadsheets to automatically calculate values for …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
formula autocomplete example

How to Enable Formula AutoComplete in Excel 2013

June 17, 2023May 27, 2016 by Matthew Burleigh

Are you familiar with a lot of the formulas in Excel, but you don’t remember the exact parameters that you need to use? Microsoft Excel …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
count the number of blank cells in a range in excel 2013

How to Count the Number of Blank Cells in a Range in Excel 2013

June 2, 2023February 8, 2016 by Matthew Burleigh

When entering data into a spreadsheet in Microsoft Excel 2013, it is not uncommon to have blank spaces that are missing data. On small spreadsheets, …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to find the day of the week from a date in excel 2013

How to Determine the Day of the Week from a Numerical Date in Excel 2013

May 30, 2023February 3, 2016 by Matthew Burleigh

Excel 2013 has a lot of helpful tools and tricks that you can use to find information about data contained in a worksheet. One of …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
trim leading spaces in excel 2013

How to Remove Leading Spaces in Excel 2013

July 3, 2023January 16, 2016 by Matthew Burleigh

You might discover that you need to know how to remove leading spaces in Excel when you have data that is difficult to work with …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
selected formulas

How to Select the Cells Containing Formulas in Excel 2010

June 8, 2023July 20, 2015 by Matthew Burleigh

When you discover an error in Microsoft Excel, and that error is part of a formula, then the level of difficulty in resolving the problem …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides, Selections
select the r1c1 reference style

How to Use R1C1 Reference Style in Excel 2010

June 14, 2023July 2, 2015 by Matthew Burleigh

If you have ever run into issues with cell references in Excel formulas, then you may be looking for another way to use them. Or …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
click calculation options, then click automatic

How to Turn on Automatic Calculation in Excel 2010

July 18, 2023May 1, 2015 by Matthew Burleigh

Are you working with a spreadsheet in Microsoft Excel 2010 where you change a cell that is included in a formula, but the result of …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
text box displaying formula value

How to Display a Formula Result in a Text Box in Excel 2010

July 17, 2023April 7, 2015 by Matthew Burleigh

Text boxes can be a useful tool in Microsoft Excel. One particular example is when your spreadsheet has a lot of data in it, but …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
click the formulas tab

Why Is Excel 2010 Showing the Formulas Instead of the Answers?

June 23, 2023March 25, 2015 by Matthew Burleigh

You may discover that you need Excel to show results instead of formulas when you enter a formula that remains visible. An Excel spreadsheet can …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
the excel 2013 formula bar

How to Hide the Formula Bar in Excel 2013

August 7, 2023October 8, 2014 by Matthew Burleigh

You can hide the Microsoft Excel 2013 formula bar by clicking the View tab at the top of the window, then unchecking the Formula Bar …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
enter the max formula

How to Find the Highest Value in Excel 2013

May 31, 2023September 17, 2014 by Matthew Burleigh

Excel 2013 offers a large number of useful formulas that will help you to find or calculate important information from your spreadsheet data. Whether you …

Read More

Categories Mobile Devices Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
enter the datedif formula

How to Find the Number of Days Between Two Dates in Excel 2013

July 20, 2023July 23, 2014 by Matthew Burleigh

Excel worksheets can contain all types of different data, including formulas (like one that lets you subtract in Excel), text, numbers, pictures, and dates. Dates …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
check the box to the left of formula bar

How to Show the Formula Bar in Excel 2013

June 17, 2023July 1, 2014 by Matthew Burleigh

The layout and appearance of your Excel 2013 installation can be customized in a number of different ways. There is an area of the default …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to view formulas in excel 2013

How to Show Formulas in Excel 2013

July 17, 2023June 14, 2014 by Matthew Burleigh

Learning how to show formulas in Excel 2013 is a helpful way for you to determine why you might not be calculating the desired result …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to create a formula in Excel 2013

How to Create a Formula in Excel 2013

June 20, 2023May 28, 2014 by Matthew Burleigh

There is a lot of utility that can come from organizing data in an Excel worksheet. Information is sortable and easy to edit, and you …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2013, Microsoft Excel How-To Guides
how to insert latin text in word 2013

Quickly Add Latin Text in Word 2013

July 3, 2023May 24, 2014 by Matthew Burleigh

You might find that you need to add a Latin paragraph to a document in Word 2013 when you need to view the structure of …

Read More

Categories Programs Tags Formulas, Microsoft Word 2013, Microsoft Word How-To Guides
how to find the median in excel 2010

How to Find a Median in Excel 2010

July 26, 2023May 20, 2014 by Matthew Burleigh

Excel 2010 is a great tool when you have a lot of data that you want to compare. You can easily perform mathematical operations on …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2010 How-To Guides, Microsoft Excel How-To Guides
how to add up a column of data in excel 2011

How to Add Up a Column in Excel 2011

June 7, 2023March 29, 2014 by Matthew Burleigh

If you’ve ever used a calculator while you were putting data into a spreadsheet, you may be wondering if there is a faster method of …

Read More

Categories Programs Tags Formulas, Microsoft Excel 2011, Microsoft Excel How-To Guides
Older posts
Page1 Page2 Next →

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

  • iPhone
  • iPad
  • Apple Watch
  • Google Docs
  • Google Sheets
  • Google Slides
  • Google Chrome
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Powerpoint
  • Microsoft Windows
  • Microsoft Word
  • Firefox
  • Photoshop
  • Gmail
  • Amazon Fire TV
  • Google Drive
  • Microsoft Edge

info@solveyourtech.com
4845290651
2138 W. Union Blvd.
#1037
Bethlehem, PA 18018
United States

  • SolveYourTech YouTube
  • SolveYourTech Facebook
  • SolveYourTech Instagram
  • SolveYourTech Twitter
  • SolveYourTech Pinterest
  • SolveYourTech LinkedIn
  • SolveYourTech TikTok
  • Newsletter
  • Affiliate Disclaimer
  • Terms of Use
  • Privacy Policy
  • Contact
  • About Us
© SolveYourTech.com 2025
  • Featured
  • Categories
    • Article Topics
    • Application Guides
    • Device Guides
    • Reviews
  • Programs
    • Excel
    • Outlook
    • Powerpoint
    • Windows
    • Word
  • Devices
    • iPhone
    • iPad
    • Apple Watch
    • Fire TV
  • Web Apps
    • Chrome
    • Docs
    • Sheets
    • Slides
  • Store