+ Reply to Thread
Results 1 to 4 of 4

Replace values in formulas

  1. #1
    Registered User
    Join Date
    03-20-2008
    Posts
    9

    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
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    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
    Last edited by royUK; 03-20-2008 at 06:30 AM.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    03-20-2008
    Posts
    9
    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.

    Cheers

    Joe

  4. #4
    Registered User
    Join Date
    03-20-2008
    Posts
    9
    Sorry, Have just realised that the original example didnt include the formulas that i am querying.

    Attached is the correct one

    Cheers

    Joe
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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