Minus 35% of pricing

[Safequip]

I have a price list that I need to reduce by 35% however doing cell a minus 35% doesn't give me the answer I need, clearly I'm doing this incorrectly can anyone help me with the formula I should be using?

Thanks

 

[Xiq]

Hi Safequip,
Yes you did something incorrectly. If you have 35% in a cell, this is equal to 0.35. So you basically ask a flat reduction of 0.35.

Try something like this:

=A1*(1-0.35)

 

[Debraj]

• In a blank cell, Write 0.65 or 65%
• Now copy that cell..
• Select all the cell's having Price..
• Lets say B2:B100.
• Paste Special > Multiply (Alt + E + S + M)
• and press Enter...

 

[SirJB7]

Hi, Safequip!

There's always a dual interpretation when applying a percentage to a number. There are 2 options, and both are correct (well, relatively):
a) =A1*(1-B1)
b) =A1/(1+B1)
being A1 the original amount or number (let us say 1000) and B1 the percentage (in this case 35%)

In my opinion in a) you're decreasing the value by a 35%, and that'll be my 1st choice, but there are people (usually vendors or resellers that add/subtract percentages chained/stacked to cost values) who think that b) is the correct case.

Whenever you're talking about little percentages (1%, 2%), the figures are very similar, which I think that it's the confusing concept, but when they're higher (as in this case, 35%) the difference is very notable.

Hope it helps.

Regards!