Excel Formulas - Add Category
Master the essentials of data calculation with our step-by-step guide on how to add an Excel formula. Learn to streamline your workflow, use popular functions, and automate tasks to save time and increase accuracy in your spreadsheets today.
Excel Formulas to Sum Numbers with Text Units
Learn how to sum numbers with text units (like "kg" or "pcs") in Excel using a simple formula with SUMPRODUCT and SUBSTITUTE.
Excel Formula to Add Standard Hours and Overtime Minutes
Learn the simple Excel formula to add standard hours and overtime minutes together for accurate payroll and timesheet calculations.
Excel Formulas for Adding Dynamic Arrays with Spill Ranges
Learn how to add dynamic arrays in Excel using the spill operator (#) to create formulas that automatically expand and update with your data.
How to Add Hexadecimal Codes and Decimal Numbers in Excel
Learn how to use Excel's HEX2DEC and DEC2HEX formulas to quickly add hexadecimal codes with decimal numbers in your spreadsheets.
Excel WORKDAY Formula for Adding Business Days with Variable Holidays
Master the Excel WORKDAY formula to easily add business days to any date while excluding weekends and custom, variable holidays.
Excel Formula to Sum Roman Numerals and Arabic Numbers
Learn how to easily add Roman numerals and Arabic digits in Excel using a simple formula with the ARABIC and ROMAN functions.
Excel Formula to Sum Merged and Unmerged Cell Ranges
Master the Excel formulas needed to seamlessly add merged cell values with unmerged cell ranges and solve calculation errors with this quick guide.
How to Convert Base Prices Using Currency Exchange Rates in Excel
Learn how to write an Excel formula to multiply base prices by currency exchange rates for quick and accurate multi-currency calculations.
Excel Formulas for Adding Specific Time Intervals to Date Values
Learn how to use Excel formulas to easily add specific time intervals-like days, hours, months, or years-to any date value.
Excel Formulas for Calculating Subtotals and Grand Totals
Learn how to use the Excel SUBTOTAL formula to quickly calculate group subtotals and an accurate grand total without double-counting.
Excel Formula to Convert and Add Fractional Inches and Decimal Feet
Learn how to use an Excel formula to easily convert and add fractional inches with decimal feet for precise measurement calculations.
How to Add a Percentage to Price in Excel
Easily add a percentage to an existing price in Excel. Learn the simple formula and step-by-step method to calculate price increases and markups fast.
Excel Formula Guide: Adding Hours Beyond the 24-Hour Limit
Learn how to sum and display total times exceeding 24 hours in Excel using a simple formula and the custom `[h]:mm` formatting trick.
Excel Formulas for Adding a Prefix to Non-Empty Cells
Easily add a prefix to non-empty cells in Excel using a simple IF formula while keeping blank cells empty. Learn the quick step-by-step method.
How to Add Leading Zeros in Excel to Match a Fixed Length
Learn how to use simple Excel formulas like the TEXT function to easily add leading zeros and format numbers to a specific fixed length.
How to Add Days to a Date Excluding Weekends and Holidays in Excel
Learn how to use the Excel WORKDAY function to easily add days to a date while automatically excluding weekends and custom holidays.
How to Add a Suffix to Cells Containing Specific Text in Excel
Learn how to use an Excel formula to automatically add a suffix to cells containing specific text or keywords in this quick step-by-step guide.
How to Add Months to Dates in Excel Based on Subscription Cycles
Easily calculate subscription renewal dates in Excel using the EDATE formula to add months based on monthly, quarterly, or annual billing cycles.
Excel Formulas to Add Time Intervals to a List of Timestamps
Easily add hours, minutes, or seconds to a list of timestamps in Excel with this simple guide to quick and accurate time formulas.
Excel Formula to Sum Only Visible Rows in a Filtered Range
Learn how to use the Excel SUBTOTAL formula to sum only visible rows in a filtered range, easily ignoring hidden cells in your calculations.
Excel Formulas for Generating Dynamic Sequential Numbers in Lists
Learn how to automatically add sequential numbers to a dynamic Excel list using the SEQUENCE formula so your row numbers update instantly as data changes.
Excel Formulas to Combine Text Values with Commas
Learn how to use Excel's TEXTJOIN formula and other simple methods to easily combine text values from multiple cells separated by commas.
How to Insert a Line Break in Concatenated Excel Formulas
Learn how to use the CHAR(10) function in Excel to easily insert line breaks between concatenated text strings for cleaner, well-formatted spreadsheets.
Excel WORKDAY.INTL Formula for Adding Business Days with Custom Weekends
Learn how to use Excel's WORKDAY.INTL formula to easily add business days using any custom weekend schedule and holiday list.
Excel Formula to Apply Target Percentage to Dynamic Array Ranges
Learn how to easily apply a target percentage to a dynamic array range in Excel using simple formulas and the spill (#) operator.
How to Insert Hyphens After Every Fourth Digit in Excel
Easily format your data with this step-by-step guide on how to use Excel formulas to automatically insert hyphens after every fourth digit.
Excel Formulas to Automatically Add Decimal Places to Whole Numbers
Learn how to automatically add decimal places to whole numbers in Excel using quick formulas and built-in formatting settings.
How to Calculate Weighted Values in Excel Using Variable Coefficients
Learn how to use Excel formulas like SUMPRODUCT to dynamically add weighted values based on variable coefficients with this easy, step-by-step guide.
How to Dynamically Add Rows in Excel Based on Checkbox Selection
Learn how to dynamically add and filter Excel rows based on checkbox selections using the FILTER formula. Automate your spreadsheets instantly!
How to Calculate Tiered Year-End Bonuses in Excel
Learn how to calculate tiered year-end bonuses in Excel using formulas like IFS and VLOOKUP to easily reward employee performance.