+ Reply to Thread
Results 1 to 3 of 3

Multiplication with an empty cell

  1. #1
    Registered User
    Join Date
    03-24-2016
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    37

    Multiplication with an empty cell

    Hi guys,
    I have the following question, I am doing a spreadsheet there I have 5 columns.
    First column - description (text no problem there)
    Second column - a number (no problem - you input it manually)
    3rd column - a number again manual input
    4th column - number again, manual input

    5th column must be equal to the multiplication of the 2,3 and 4th column.
    For example in column five (E2) the formula must be =B2*C2*D2. The problem is that one of the 3 columns where you input the numbers manually will be empty. So if one cell is empty the answer will automatically be 0.

    I need some sort of if function where it takes into account only 2 of the 3 cells where i can input numbers in (at least I think that I need an if function :D)

    I have included a very simple spreadsheet with the problem.
    Attached Files Attached Files
    Last edited by Tsetsko; 03-30-2017 at 02:29 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,826

    Re: Multiplication with an empty cell

    Like the SUM() function, the PRODUCT() function will ignore blanks and text. I would suggest trying that instead of the multiplication operator =PRODUCT(B2:D2) https://support.office.com/en-us/art...c-80982a0512ce
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-24-2016
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    37

    Re: Multiplication with an empty cell

    Awesome. this solved my problem!


    Thanks!

+ 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. Multiplication Grid Formula in one cell?
    By Belshazzar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2016, 02:02 PM
  2. Multiplication of several numbers in one cell
    By dinahajjar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2014, 05:00 AM
  3. multiplication in one cell but result in another??
    By excsal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 01:43 AM
  4. [SOLVED] Cell multiplication mystery
    By krookra in forum Excel General
    Replies: 3
    Last Post: 05-02-2012, 10:14 AM
  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. Multiplication in one cell
    By Need to Multiply within one cell in forum Excel General
    Replies: 1
    Last Post: 06-22-2005, 12:05 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