Results 1 to 4 of 4

multiply several different rows in a colum beginner

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    michigan
    MS-Off Ver
    Excel 2007
    Posts
    2

    multiply several different rows in a colum beginner

    see attached file for example. so i have a chart. say it has 5 colums a,b,c,d,e and 3 rows 1,2,3. (it really has hunreds) all rows have different values (numbers). some rows need to be multiplied. lets say b1 is 3 and b2 is 5, and d colums are blank. what if i need to autommatically multiply each value in b colum by 2 to make d1 now have 6 and d2 to have 10? is there a way to do this without having to conditionally format each row hundreds of times?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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