# Replace values in formulas

1. ## Replace values in formulas

Hi there,

First time posting but i need your guys help.

Please see the attached file for the problem i am having.

I have a discounted total and am trying to remove the discount to gain the original amount then apply new discount factors to the undicounted amount to get a new value, although when i apply the same discount factors there is a difference. I think its to do with the 100+10%=110 -10%=99 type thing, but am not sure and my brain hurts.

Any help appreciated.

Kind Regards

Joe

2. Welcome to the Forum.

Relax with some light reading - the Forum Rules. You will see that you need to use a Thread Title that describes your problem, not simply "Help". The title is needed to help members decide if they can help and also to aid others searching for help.

To get the original value you need to divide the dicounted value by 100-the discount, then multiply by 100.
Assuming the discounted value is in A1, the discount rate in B1 use this formula

=A1/(100-B1)*100

3. Sorry about that, patience is the key i think.

I have an amount paid to "A" which is a discounted cost. I have calculated the original amount previous to the discount and now if i apply those same discount factors to the original amount "B" i want to see the same figure as the original. So i can see a difference of 0 which will validate that the formula id correct, so i can then go on and put in new discount costs on the original amount to give me a new discounted cost.

If that makes sense.

Cheers

Joe

4. Sorry, Have just realised that the original example didnt include the formulas that i am querying.

Attached is the correct one

Cheers

Joe

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1