Trouble subtracting percentages

Hello

I have a simple Excel price that I need to convert to Sterling and deduct 30% to get my cost price. Same formula for every cell.

I get as far as converting the exchange rate, i.e D8/1.25 = .304
but cannot get the 30% to deduct. It ends up calculating what 30% is, but not deducting it.

D8/1.25*(-30%) answer = .091 Correct answer should be 0.2128

Thanks
David

Hi Debtail, welcome to the forum! :)

Excel doesn't understand the syntax you're trying to use. I think this might help: Wikipedia: Percentage: Percent increase and decrease (http://en.wikipedia.org/wiki/Percentage#Percent_increase_and_decrease)

Hi Cas
Thanks for the suggestion, but need an absolute result. We did use this =(0.38-(0.38/100*30))/1.25

which gave the correct answer, 0.2128 but I cannot apply it, (copy and paste) to every cell.

Kind regards
David

Sure you can, nothing is stopping you from putting the variable (D8) back in for the value (0.38).

Mind you, the expression you're using could be simplified easily so that the variable only appears once, but it's not essential and I don't think there's much point in trying to teach arithmetics here... :-\

I do this =(C8-(0.38/100*30))/1.25 but still get an eror reference to a 'circular reference'

Sorry - wrong formula, I use this =C8-(/100*30)/1.25 but still get an error message
Can you suggest a correct formula please

Sorry - wrong formula, I use this =C8-(/100*30)/1.25 but still get an error message
Can you suggest a correct formula please

When you get the message box informing you that your formula has an error, click on the Help button and have a thorough read on the relevant sections, particularly "How to enter a simple formula" and "Remove or allow a circular reference".


Colin

Thanks Colin, but can anyone just gvie me a formula please...I am not an expert at this, and do not waht to do 20 pages of calculations manually

David,

Now that you have read the helpfiles do you understand why you are getting an error?

Colin