ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us

Tag: Subtraction Formula

Get the Original Price from Percentage Increase/Decrease

Get the Original Price from Percentage Increase What was the original price of the smartphone before the price increase? Current prices are in column B, price after a 20% increase (column C). What is the formula to get the original smartphone price before the percentage increase? …
Full Article
How to Add and Subtract Percentage in Excel

How to Add/Subtract Percentage in Excel

Add Percentage in Excel What is the price of each cell phone after the price increase? You can use the multiplication and addition formula to get prices after a percentage increase. The Formula =number*(1+percentage_increase) How does the formula work? =B2*(1+C2) The first calculated formula is (1+C2). …
Full Article
Add time in excel

How to Add Seconds, Minutes and Hours to a Time in Excel

Excel stores date value in integer number and time value in decimal number. 1 day = 24 hours 1 hour = 1/24 = 0.041666667 1 minute = 1/(24*60) = 1/1440 = 0.000694444 1 second = 1/(24*60*60) = 1/86400 = 0.0000115740740740741 To add seconds, minutes, or hours …
Full Article
How to add days, weeks, months, years to date in Excel

How to Add Days, Weeks, Months and Years to a Date in Excel

How to add DAYS to a date in Excel Excel stores date value in integer number, to find out n days after a date, add the date and number of days. The Result The formula in cell B2 adds a date in cell A2 with number …
Full Article
How to Subtract Multiple Cells from One Cell in Excel

How to Subtract Multiple Cells from One Cell in Excel

For example, there are data such as the image below. How is the fastest way to subtract numbers in column A with a number in cell B1? Subtract Multiple Cells Using Formula You need an absolute cell reference for subtracting numbers with a number. Make the …
Full Article

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh