Results 1 to 6 of 6

Getting a 0 value when formula multiplies 2 cells but 1 is empty

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2015
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    2

    Getting a 0 value when formula multiplies 2 cells but 1 is empty

    Hello everybody, just signed up since i cant get it figured out myself.
    Question itself will show i am not really great with excel.



    I am using this in C10 to C18
    =ABS(A10-B10)
    To get the difference between A10:A18 and B10:B18.
    However A16 is 58009 and B16 is blank but C16 is still showing 58009 while it has to be 0.
    Makes sense with the formula used.

    What is a better formula i can use to calculate this?

    Thanks
    Last edited by YvesT; 06-05-2015 at 08:15 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A simple question requiring a simple answer
    By Pedros in forum Excel General
    Replies: 3
    Last Post: 07-18-2006, 06:45 AM
  2. [SOLVED] Simple Simple Excel usage question
    By BookerW in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 05:05 PM
  3. [SOLVED] a small question
    By Jimmy Pop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2005, 03:05 PM
  4. [SOLVED] NEED HELP, SMALL QUESTION
    By DiskDoctor in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 09:06 AM
  5. Simple Cash Flow Small business
    By Ed West in forum Excel General
    Replies: 0
    Last Post: 04-10-2005, 12:07 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