Adding

[Zugdud]

Due to software restrictions of our mrp system, I need to import a list of values and subtract 10% from the values. The only problem is...these values can not have a % discount so what im trying to do is figure out a way within excel or similiar spread sheet program to just add an ammount to all the values which will make them equal to the starting values after subtracting 10%.

for example, simply adding %10 to 100 and then subtracting %10 isn't going to give me a 100 again. Is there any way to do this? Ugh...I wish I remembered math =)

 

[Katy44]

Are you not just trying to calculate 90% of the value?

 

[Zugdud]

No, unfortuatly it's not that easy. I have to import a list of base prices with a discount %, the system then figures the final price. Only problem is that, for this particular list im importing...I want the list price to = the actual price. So I have to figure out a way to inflate the base price so that when I deduct a %...say 10%, off all the values the final price will = the base price.

 

[sdebo2]

The report should be performing this calculation Value* 0.90 . This is the same as subtracting 10%.

In excel take your Value/0.09. This will increase the value. This should make the value in the report the same as your original, less any rounding error.

 

[Katy44]

Ah
I think you need to add on one ninth of your original figure

 

[Zugdud]

Genious! Thankyou very much, that worked EXCELLENT!

 

[Zugdud]

Genius...even, kinda looks bad spelling that word wrong

 

[kmcginn]

Here's the Math:

Divide your original value by 90% or .9. That will give you the new base value. When you subtract 10% you'll be back to your original.

If you want the equation, here it is:

n - .10n = y where n represents your new price, and y represents your original price. It simplifies to .9n = y and to solve you simply divide y (your orginal number) by .9. You may encounter a few rounding issues, but just round up and you'll be fine.

I knew my days of teaching High School Math would come in handy someday!! lol