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