Dueling Excel 002

Decrease Values By 35%

DESCRIPTION

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%.

WORKBOOKS

Download “Dueling Excel 001-010” Dueling-Excel-001-010.zip – Downloaded 6 times – 116 KB




Be the first to comment

Leave a Reply