Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Minus 14 (2002 SP 2)

    I need to change all the numbers in a book index and it has to be done manually. Each number has to have 14 subtracted from it. To make this easier, I thought I coud set up an Excel work sheet with the numbers 15 through 256 in column A and the corresponding numbers (1 through 242) in column B. Can someone instruct me as to automatically fill column A with numbers 15 through 256 and insert a formula in column B that would subtract 14 from each cell in column A? Thanks.
    Clark

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Minus 14 (2002 SP 2)

    Try entering 14 in blank cell, copy it and then select your index numbers, goto Edit, PasteSpecial and select Subtract.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Minus 14 (2002 SP 2)

    Thanks. I figured out a way.
    Clark

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Minus 14 (2002 SP 2)

    Thanks Andrew

    Very useful for me too. Ok then, let me crank this one up a little further then!!! How would I subtract 15% from a range using this method.

    Your assistance would be greatly appreciated

    Jerry
    Jerry

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Minus 14 (2002 SP 2)

    put 0.85 in a cell
    copy the cell
    paste special - multiply

    Steve

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Minus 14 (2002 SP 2)

    Thanks Steve

    The answer was a bit obvious come to think of it <img src=/S/blush.gif border=0 alt=blush width=15 height=15> .

    I was putting in 15% and then subtracting and getting horrific results.

    Cheers, Jerry
    Jerry

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Minus 14 (2002 SP 2)

    You were just subtracting 0.15 (=15%) from each number, which is not the same thing as subtracting 15% "of the current value" which is implied in your question.

    Steve

Posting Permissions

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