How to add a percentage discount to a column in Numbers MAC OSX?

Question

How to add a percentage discount to a column in Numbers MAC OSX?

How would I go about adding a percentage discount to an entire column in Numbers? I have a set of prices for products I am looking to discount by a certain percentage for an e-commerce store. Then need to convert .csv format.

I am running Numbers 3.2.

Please let me know or reference to a source that would provide step by step detail?

Thank you in advance

"TheNumbersGuy"

MacBook Pro (Retina, 15-inch, Late 2013), OS X Mavericks (10.9.5)

Posted on Apr 6, 2015 2:45 PM

Reply

Answer 1

t quinn

Level 5

7,063 points

Apr 6, 2015 4:56 PM in response to thenumbersguy

Hey Guy,

Here is a simple approach that will let you change the discount (B1)

I show the formula in row 3 but you can fill your entire column. If you are only interested in one discount you can replace $B$1 with your value (.2 for 20%, etc.).

quinn

Reply

Answer 2

t quinn

Level 5

7,063 points

Apr 6, 2015 5:15 PM in response to thenumbersguy

Hi Guy,

I suggest the column right next to your prices.

In the first cell, type "=". The formula editor will pop up.

Click the cell with your prices,

type "-(.2*"

click the cell with your prices,

type")"

This is what you should see in your editing box (if you want 20% off)

To fill the rest of your column, hover your cursor over the bottom of the cell (after you hit return). You will see a yellow dot. This can be dragged down to fill.

quinn

Reply

Answer 3

Jun 9, 2015 1:36 PM in response to t quinn

Hi Quinn

I tried using the formula above and it does not work .Numbers gives me a message that there is a syntax error.

Any ideas? I am working with Column F and tried using this formula to see if it would work. Once I figure out how to do I am looking to mark up the prices in column F 10 percent. I have Column G open for the new pricing.

Thanks,

Reply

Answer 4

Apr 6, 2015 5:01 PM in response to t quinn

Hi thanks for your help.I don't have much experience with Numbers. Where do I add the formula to/ how do I add it? Am I able to add to entire column?

Reply

Answer 5

t quinn

Level 5

7,063 points

Jun 9, 2015 7:37 PM in response to thenumbersguy

Hi Guy,

Please post the formula you are using copied from your table. Copy/Paste is fine or you can take a screenshot.

quinn

Reply