Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2002
    New Jersey, USA
    Thanked 0 Times in 0 Posts

    Writing a Formula (9.2.2720)

    I have a 20 page price list in Excel, and I want to write a formula to change all the prices in a column at one time to reflect a yearly price increase, such as 3%. How would I write such a formula and apply it to this document?

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Springfield, Ohio, USA
    Thanked 2 Times in 2 Posts

    Re: Writing a Formula (9.2.2720)

    In a blank cell enter 1.03
    Edit | Copy
    Select the prices in the column that you want to change
    Edit | Paste Special | Operation: Multiply | OK
    Clear the cell that contained 1.03
    Correct any formats that changed

    If the prices were numbers, they will be replaced will new numbers that are 3% bigger. If the prices were from formulas, the formula will be updated to include a 3% increase. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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