Excel Forum



Mr Excel & excelisfun Excel Trick #2: Decrease Values By 35%


See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a column of values:
Mr Excel: Create formula for remaining percentage (1 + decrease), copy remaining percentage, Paste Special, Operations Multiply, Values. Subtract 35% from a column of values.

excelisfun: Create formula for remaining percentage (1 + decrease), create new column with formula (Original Price * remaining percentage) to calculate column of values that subtract 35%.
MrExcel's Learn Excel #966 - Reduce by 35%
YouTubersLoveExcel#16: Percent Number Formatting Tricks





Got a Question? Ask it Here in the Forum.