Replace values in formulas
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.
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
Last edited by royUK; 03-20-2008 at 06:30 AM.
Sorry about that, patience is the key i think.
The answer didn't really answer my problem.
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.
Sorry, Have just realised that the original example didnt include the formulas that i am querying.
Attached is the correct one
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1