Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    I am using the formula "=IF(ISERROR(DATEDIF(B10,B11,"d")),"no next date",DATEDIF(B10,B11,"d"))" to output column "C".
    I want to output a cell name [B11] in output text [C10] so it would read "no entry B11". Is it possible to use a formula that would calculate the cell to be placed in the output? I do not want to write a specific formula for each "C".

    See attached spreadsheet.

    Thanks.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by Len Smith View Post
    .......
    See attached spreadsheet.
    .......
    Nothing was attached.

    Try this within your formula for C10 ...
    "no entry"&" "&CELL("address",B11)

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Incorporate the following into your formula:

    =Cell("address",B11)

    It will return $B$11 as text

    when you copy down the next cell would be $B$12 etc. If you copy right the next cell would be $C$11 etc.

    Hope this helps.

    Tom Dutie

  4. #4
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Thanks.

    Anyway to eliminate the $s ?

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by Len Smith View Post
    Thanks.

    Anyway to eliminate the $s ?
    Try this to eliminate the $'s.....
    "no entry"&" "&"B"&CELL("row",B11)
    Assumes you always want a cell from Col B.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Anyway to eliminate the $s ?
    =SUBSTITUTE(CELL("address",B11),"$","")

    Steve

  7. #7
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Tim, Tom, Steve, Thanks.

    Tim, your suggestion to eliminate $ worked fine.

    Steve, How would I incorporate your formula into my modified formula?
    =IF(ISERROR(DATEDIF(B10,B11,"d")),"no entry"&" "&"B"&CELL("row",B10),DATEDIF(B10,B11,"d"))

  8. #8
    3 Star Lounger
    Join Date
    Dec 2009
    Posts
    212
    Thanks
    36
    Thanked 0 Times in 0 Posts
    Steve,
    Never mind, I figured it out. Thanks.

Posting Permissions

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