ExcelCSE.com

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

Get the Original Price from Percentage Increase/Decrease

How to Add and Subtract Percentage in Excel

How to Add/Subtract Percentage in Excel

How to Extract Day, Month and Year from Date in Excel

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

How to Extract Day, Month and Year from Date in Excel

Excel provides three different functions to extract a day, month, and year from date. The following is an explanation of each function to extract each value. Extract Day from Date in Excel The formula =DAY(A2) The result If you want to extract the day from the …
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

Posts navigation

1 2 3 4 … 23 Next

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