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




Be the first to comment

Leave a Reply