+ Reply to Thread
Results 1 to 4 of 4

Multiplication by one of two cells, depending on which holds value

  1. #1
    Registered User
    Join Date
    09-04-2017
    Location
    London, England
    MS-Off Ver
    Microsoft365
    Posts
    9

    Multiplication by one of two cells, depending on which holds value

    I am trying to populate O13 with the result of K13 multiplied by either I13 or J13, depending on which holds a value. If I13 holds a value, J13 will always be blank and vice versa.

    Any help you can give would be greatly appreciated.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Multiplication by one of two cells, depending on which holds value

    Why not use:

    =(K13*(I13+J13))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    09-04-2017
    Location
    London, England
    MS-Off Ver
    Microsoft365
    Posts
    9

    Re: Multiplication by one of two cells, depending on which holds value

    Thanks Glenn - Looks like I have been severely overcomplicating things!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Multiplication by one of two cells, depending on which holds value

    You're not allowed to do that.... Overcomplication is my territory; I do it all the time.

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. [SOLVED] #value for multiplication when referenced cells contain formulas
    By carrollkm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2015, 11:38 AM
  2. Multiplication of cells in different worksheets
    By joelleong08 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2014, 10:15 AM
  3. Insert formula depending on cells depending of variables
    By elmexicano87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2014, 01:22 PM
  4. How to do multiplication between cells and sum the values up
    By tiongsquare in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2012, 11:43 PM
  5. How to ignore empty cells in multiplication
    By bbheli in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 01-30-2011, 10:46 AM
  6. Product (multiplication of cells)
    By Mbrolass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2007, 01:15 PM
  7. [SOLVED] Matrix multiplication with empty cells
    By Ingrid Voigt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2005, 12:06 AM

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