+ Reply to Thread
Results 1 to 3 of 3

Multiplication by if condition if cell not empty

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Multiplication by if condition if cell not empty

    you can see in the attached file in the formula which is in cell M6 multiplication
    by cell J6 value & cell L6 value & in cell M7 in formula multiplication by cell K7 value
    & cell L7 value,
    I want that if in column K any value it means if cell not empty in column K then
    multiply by that cell which is in column K , else multiply by value which is in column J,
    so give me the solution
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Multiplication by if condition if cell not empty

    =if(isblank(k6),j6*l6,k6*l6)

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: Multiplication by if condition if cell not empty

    thanks for solution, now my problem is solved.

+ 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] Multiplication with an empty cell
    By Tsetsko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2017, 02:28 PM
  2. Count Until empty cell (condition to stop counting)
    By danielpp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2016, 02:50 PM
  3. Replies: 1
    Last Post: 05-26-2014, 01:31 PM
  4. Multiplication of values in same row if condition is met
    By amirah_almu7aka in forum Excel General
    Replies: 9
    Last Post: 05-30-2012, 12:11 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. [SOLVED] Conditional formatting - on an empty cell condition in _another_ cell?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-29-2006, 04:00 PM
  7. 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