Results 1 to 4 of 4

formula returns wrong result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    formula returns wrong result

    Have this code in cell E21
     =SUM(C21-D21)*(MATCH(B21,$AC$25:$AC$44,0)*5)
    works
    if I have number in D21 perfect. How can I make it so if D21 has no number E21 will show 0. Now it picks up Sum of C21 and fills
    E21 with number even id D21 has no number. Not sure how to make formula return 0 if D21 is empty?.


    Thanks z
    Z
    Last edited by zplugger; 03-12-2014 at 01:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-06-2014, 03:54 AM
  2. Formula Problem
    By Parit in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2013, 09:02 AM
  3. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  4. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  5. Problem reading formula with ActiveCell.Formula
    By Matija in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 06:10 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