I Need To Decrease All of the Numbers in a Row by 10%

Question

Level 1

0 points

I Need To Decrease All of the Numbers in a Row by 10%

I exported my ecommerce products to an csv file and I want to decrease all of the product values by 10%. How can I do this easily so that I do not have to change hundreds of values manually? Thanks

Posted on Jul 11, 2014 9:13 PM

Reply

Answer 1

Yellowbox

Level 7

20,383 points

Jul 12, 2014 3:45 AM in response to vforte0

Hi vforte,

In Numbers, use formulas in another row to calculate 10% less. Multiplying by 0.9 will do it.

Formula in cell B3 (and Fill Right):

=B2×0.9

Regards,

Ian.

Reply