+ Reply to Thread
Results 1 to 2 of 2

Want cell to return no result

  1. #1
    Forum Contributor
    Join Date
    01-11-2007
    Posts
    127

    Want cell to return no result

    Does anyone know how to make the formula below return nothing unless AB1 has an entry in its cell?

    =SUM(X1+AE1)

    Unless AB1 has information in it, I want this cell to appear blank. Thanks in advance.

    Dan

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Want cell to return no result

    Use an IF perhaps ?

    IF(AB1="","",SUM(X1,AE1))

    On an aside... the advantage to using SUM over + is that it does not explicitly coerce... for ex.

    X1 = "apple" (user error)
    AE1 is 10

    =X1+AE1 --> #VALUE! as X1 is not numeric...
    =SUM(X1,AE1) --> 10 given the SUM will only look at numeric values...

    my point... there is thus little value in using

    =SUM(X1+AE1)

    as the benefits of the SUM are negated by the explicit coercion taking place within the SUM itself therefore if using X1+AE1 dispense with SUM and conversely if using the SUM dispense with the + operator and use , to delimit the ranges to be summed
    (you are constrained in terms of how many areas you may delimit in the SUM)
    Last edited by DonkeyOte; 11-09-2009 at 06:46 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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