Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Alter a percentage

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Total Units Destroy Remaining %
    100 99 1 100%


    I'm dividing the Remaining by the Total to obtain the %. I need to change each % that less than 250% and make it 250%, in which case I would have to alter the Destroy #. Is there a formaula that can assist me rather than doing it manually?

    Thanks!!

    Anthony

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,426
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    I am not clear on your question.
    Do you mean 25%

    New Column C =MAX(B2,0.75*A2-B2)
    Remaining % =(A2-B2-C2)/A2

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for responding Dave! I did mean 250%. I actually have 5 columns.

    Total Sellable Destroy Remaining %
    100 30 50 50 167%

    I'm dividing the Remaining by the Sellable to obtain the %. I would need to change the 50 (Destroy Column) to 25 in order to obtain the desired 250%. Does this make more sense?

    Thanks again!!!

    Anthony

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-25 21:29, Anthony G. wrote:
    Thanks for responding Dave! I did mean 250%. I actually have 5 columns.

    Total Sellable Destroy Remaining %
    100 30 50 50 167%

    I'm dividing the Remaining by the Sellable to obtain the %. I would need to change the 50 (Destroy Column) to 25 in order to obtain the desired 250%. Does this make more sense?

    Thanks again!!!

    Anthony
    Hi Anthony:
    If your Total, Sellable,Destroy, Remaining,% are in cells A2,B2,C2,D2,and E2,
    then for 250pct you need to put the following formula in F2

    =IF(E2<250%,D2*250%/E2,E2)

    HTH
    Please post back if it works for you ... otherwise explain a little further and let us take it from there!

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,426
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    Purely arithmetic ......

    With 30 in B6
    Remaining =B6*250%
    % =G5/B5 250%

    Or to adj (information?)

    new column Revise =B5*250%-D5
    new col G new Remaining =D5+F5

    % =G5/B5 250%

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave and Yogi............Thanks!!!!

    Worked just fine.

    Anthony

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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