+ Reply to Thread
Results 1 to 3 of 3

Inserting the same formula/multiplier across multiple cells

  1. #1
    Registered User
    Join Date
    09-20-2008
    Location
    NYC
    Posts
    2

    Inserting the same formula/multiplier across multiple cells

    I have an excel spreadsheet with with 17 numeric columns that represent baseball stats. I would like to multiple all of the data in each of those columns and rows (20) by 1.434. Rather than go in and take each individual # in each column and manually key in =#*1.434 I would like to know how to globally apply that formula across the spread sheet. Manually keying would take me 45-60 minutes per sheet.

    PURPOSE OF FORMULA: I am attempting to project baseball stats from the 1994 strike season for each team and each player over the 162 games that should have been played. Since each team played a uneven amount of games I am applying different amounts in the formula to bring them close to 162. I can send the spreadsheet to anyone who is interested if they'd like to tinker with it. I think I uploaded it here as well94Chisox.xls

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,467
    If you just want to change the value then you can enter 1.434 in a spare cell.
    Copy that cell and then select the range to change. Use Paste Special > Multiply.

    For a more permanent and flexibly change you will need code and a cell to store the value in.
    Enter the factoring value in a cell, A27.
    Then select the range to change and run this macro.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-20-2008
    Location
    NYC
    Posts
    2
    Thanks, it worked like a charm !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple cells referred to in IF formula query
    By Danofire in forum Excel General
    Replies: 5
    Last Post: 06-24-2008, 07:00 PM
  2. Multiple cells and ignore empty cell
    By fbjorkma in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-01-2008, 04:02 PM
  3. Resetting multiple cells (to zero)
    By Caleo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2007, 06:03 AM
  4. Adding text to multiple cells (prefix?)
    By PaBowSniper in forum Excel General
    Replies: 3
    Last Post: 12-28-2007, 01:26 PM
  5. Multiple Active Cells?
    By MasterCoder84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2007, 04:30 PM

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