+ Reply to Thread
Results 1 to 4 of 4

Repetitive sheet references in formula

  1. #1
    Registered User
    Join Date
    01-16-2010
    Location
    vancouver, canada
    MS-Off Ver
    Excel for MAC 2018
    Posts
    59

    Repetitive sheet references in formula

    Could you please help me simplify this formula by reducing the number of times the worksheet reference needs to be repeated? Thank you!

    =IF(AND(ISNUMBER('Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$O$5),ISTEXT('Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$E$5),ISTEXT('Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$C$5)),'Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!O5,FALSE
    Last edited by eugbed; 04-28-2010 at 11:17 PM. Reason: forum moderator request

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Re: repetitive sheet references in formula

    if you only have a few cells to refer to you could make each a Named Range
    such as MacO5 ='Macintosh HD:Users:name:Desktop:2010 points:[2010 MREC Template.xls]results'!$O$5

    but if you have many many sheet references this is probably not practical

  3. #3
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    174

    Re: repetitive sheet references in formula

    Can you get rid of 'Macintosh HD:Users:name:Desktop:2010 points:' and see if it still gives you desired results?

  4. #4
    Registered User
    Join Date
    01-16-2010
    Location
    vancouver, canada
    MS-Off Ver
    Excel for MAC 2018
    Posts
    59

    Re: repetitive sheet references in formula

    Thanks - I will try both of these suggestions

+ 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