+ Reply to Thread
Results 1 to 9 of 9

Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Unhappy Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    I'll try not to be long winded here but I've been working on this for hours and am stumped:

    I have a bunch of data (128x128 grid) on Sheet1.
    On Sheet 2 I need the data from sheet1 to be multiplied by a multiplier (unique multiplier per each row*)
    *Sheet2 Column EA contains the multipliers

    I have tons of blank cells on Sheet1 and need to have the blanks carry over to Sheet2.
    Another caveat is that several of the multipliers in Column EA are 0.000.
    When that is the case I need the data in that row to show 0.000 only if data is filled in a cell--again all other cells would remain blank.

    I have experimented with Paste special (by copying all data from sheet1 to sheet2) and have tried to write a formula that makes this work but I haven't figured it out yet.

    ANY advice or ideas? :/

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    can you post a sample workbook with some data and expected results.

    To attach a sample workbook.

    When you are in Advanced reply, click on the paperclip to open the upload window.

    View Pic
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    Thank you! I hope this helps.
    I just took a very small sample of my workbook.
    Sheet 1 has the current data.
    Sheet 2 is where I want to multiply the exact numbers from Sheet 1 by the light green column (G in this example)
    Sheet 3 is what I would like it to look like when it is done. (I manually coded each cell by placing an = in front of the current cell content and then added *G(row#)

    I would like to have a way to obtain the results on Sheet 3 without having to enter each cell manually. Thank you!!

    sampledataOWP.xlsx

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    here's your file. just point to the right range of cells. I used the data in Sheet3(multiplier green)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    sampledataOWP.xlsx

    regards,
    vladimir

  5. #5
    Registered User
    Join Date
    01-27-2013
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    Thank you!
    I am still getting zeros straight across my rows...is there another setting I need to change?

  6. #6
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    you have to change the ranges to your specified range of data..(point to the correct sheets and referrence cells

    did you look the sample data?

    look also for absolute references (it's the dollar signs between the column Letters or row numbers)Sheet1!$B$2:$E$5

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    you have to change the ranges to your specified range of data..(point to the correct sheets and referrence cells

    did you look the sample data?

    look also for absolute references (it's the dollar signs between the column Letters or row numbers)Sheet1!$B$2:$E$5

  8. #8
    Registered User
    Join Date
    01-27-2013
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    Okay I just noticed that attachment!
    I am trying to figure out if there is a way to keep cells that were originally blank, blank.
    I believe there I would have to create an If statement but I'm not sure how.
    Basically: IF the cells are blank...do nothing.
    IF they are not...I need to do the equation.

    Thank you so much!
    I have learned so much about excel in one week my head is going to explode!

  9. #9
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Multiplying the contents of a cell by a multiplier, leaving blank cells blank.

    yup you can use if statement

    maybe like this

    =if(isblank(theforuma),"",the formula)

    here:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

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