Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    formula needed for excel

    Hello All,
    I have a need to solve for x

    9,798 4.2% = x
    6,813 4.2% = x
    15,500 2.5% = x
    10,908 1.9% = x
    14,389 -3.0% = x
    8,950 -4.3% = x
    19,341 -7.2% = x
    12,82 -10.6% = x

    if the % is not showing it will be greater than 100 % to x ..(ie) 104.2%
    is there a formula i can use down a column to achieve this goal?
    Thank you for the help

  2. #2
    Star Lounger
    Join Date
    May 2016
    Posts
    50
    Thanks
    9
    Thanked 4 Times in 4 Posts
    i'm not sure i follow what your meaning here

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts
    first column ... current sales % is growth or decline from last year ... I am trying to find out what last years sales dollars are.

  4. #4
    Star Lounger
    Join Date
    May 2016
    Posts
    50
    Thanks
    9
    Thanked 4 Times in 4 Posts
    ahhhh, so

    x is a dollar figure

    and you basically want the percentage increase (or decrease) in a hard cash dollar figure

    ok, be back in a bit

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    If you want the line by line increase or decrease, first separate the data into two columns, then multiply.

    If there's something else you're looking for, please indicate.

    Note: your last number is missing a digit.

    Clip0015.jpg

    Or did you want the result of the increase or decrease?

    Clip0017.jpg
    Last edited by kweaver; 2016-05-21 at 18:20.

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    cvbs,

    In this example, enter the formula:

    =A2/(100%+B2)

    In cell C2 then copy down. Hope I understood you correctly,

    Maud

    CVBS.png

  7. #7
    Star Lounger
    Join Date
    May 2016
    Posts
    50
    Thanks
    9
    Thanked 4 Times in 4 Posts
    ok, so, first figure is this years sales, and the percentage is the over or under last years totals, then to find last years totals, try what i have done in this workbook, it might help

    The ROUND function can be specified to go up or down (ROUNDUP / ROUNDDOWN) without defining it, it goes to the closest 10 i think

    Formula
    Code:
    =ROUNDUP(A1-(A1*B1%),2)
    EDIT: you don't have to use the round function, a very similar affect can be managed with the cell formatting, in fact, i think the workbook i posted with the tidied up formats may very well suffice, meaning the formula could be reduced to =A1-(A1*B1%)

    workbook with some formatting to tidy the cell display....
    Attached Files Attached Files
    Last edited by Gunslinger; 2016-05-21 at 18:54.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Maud, I was unclear if the OP wanted the increase/decrease as I did or what you did. Either way, the OP has the solution!

  9. #9
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Kw,

    I was unclear to me as well. But having a dilemma looked at from different angles often offers many creative solutions.

    Maud

Posting Permissions

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