Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    How did I do it? (XL from Office 2003)

    Hi everyone;

    I have an old spreadsheet with this feature, but I don't know how I created it.
    A given cell has a formula, but its contents will be blank unless the other cells with data into the formula are filled.
    I would like to know how this came to be implemented, to use in a new application.
    I tried to copy portion of the (confidential) file, but the feature doesn't carry to the copy.
    I am attaching an example:
    I want to copy the formula into cells of column C only once, and the contents of these cells in the column be blank until y fill the corresponding ones in columns A and B.
    Any help will be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How did I do it? (XL from Office 2003)

    Hi there

    How about puitting this formula in cell C1 and copy down:

    =IF(AND(A1="",B1=""),"",A1+B1)
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How did I do it? (XL from Office 2003)

    If you'd prefer to see a result only if both column A and column B have been filled in, use
    <code>
    =IF(OR(A1="",B1=""),"",A1+B1)
    </code>
    in C1 and fill down.

  4. #4
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Re: How did I do it? (XL from Office 2003)

    Gentlemen;

    THANK YOU very much.
    I tried both approaches, and they both work.
    As usual, whenever I contact this forum, I learn something new.
    In this case, it was the ""existence.
    So, I went to Excel Help, and typed "" for search, but it doesn't find anything.
    Here I am again; now asking for a simple "tutoring" (stupid question, I know):
    Would it be correct my assumption that "" means cell filled?

    Thanks again.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How did I do it? (XL from Office 2003)

    <code>""</code> is an empty string. If a cell value equals <code>""</code>, it is blank, empty.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How did I do it? (XL from Office 2003)

    The formulas that Jezza and I posted are very similar, but there's a subtle difference: if A1 is empty and B1 is filled, Jezza's formula will return the value of B1, mine will return a blank. If both cells are filled or both cells are empty, the two formulas will return the same value. Which one you should use is a matter of preference.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How did I do it? (XL from Office 2003)

    The double quote is known as a string of null length or a Null set
    Jerry

  8. #8
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Re: How did I do it? (XL from Office 2003)

    Gentlemen,
    Thanks again.
    I went to my book (an old Microsoft Press for W95), and learned about it.
    Best regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •