Results 1 to 5 of 5

Ignore blank cell to give give non zero result

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    24

    Ignore blank cell to give give non zero result

    Hi,
    I have a sheet where in four cells in a row is to be multiplied. As the data gets populated there can be a blank cell in same row but the formula should still calculate and give the results for three cells ignoring the empty cell as zero otherwise the entire result is shown zero since all the three cells are multiplied by zero.
    Example
    Row 1 data is A1=2, B1=3, C1=blank, D1=4 F1=2*3*blank*4=24
    Row 2 data is A2=4, B2=blank, C2=5, D2=2 F2=4*blank*5*2=40

    As shown above I need this type of calculation. What I am getting is zero in F column as C1 is blank in first row and B2 is blank in second row.
    Why I want is so that excel should give me correct non zero result if I drag the cell formula to all below cells.

    File attached with measurement sheet is where I want to work on.
    Any help will be appreciated.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] condition formatting give the colour at the cell with the result
    By davide2574 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 01-12-2016, 04:39 AM
  2. Replies: 12
    Last Post: 09-19-2014, 10:18 PM
  3. [SOLVED] using a max formula on a column with no data to give a Blank result
    By Brentsa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2013, 05:42 AM
  4. [SOLVED] i have multiple lookup in my excel, its give result "0" i want blank outpu.
    By vengatvj in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-25-2013, 02:05 PM
  5. VLookup to give Blank result
    By mrcois in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2010, 11:50 AM
  6. How do I get a cell to give a result based on the month we are in?
    By SHBmgr in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2006, 05:55 PM
  7. [SOLVED] entering a26-02 into a cell give strange result
    By Anthony in forum Excel General
    Replies: 1
    Last Post: 01-27-2005, 07:06 PM

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