Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Excel 2007 » Named Cells

Named Cells

Previous | Next
Latest post Mon, Feb 8 2010 7:51 AM by raymondsmart. 2 replies.

  • Wed, Dec 9 2009 9:56 AM

    Named Cells

    Reply |Contact

    Hi all,

     

    I have this formula:  =if(SHDATE>=C18,SHPRE/12,SHPOST/12)/Q110Rate

    The underlined parts are part that are vaiable ie.  It is a different named cell.

    How do i write it so that I can use the value in A1 (SH in this case) and A2 (Q110)??

     

    Thanks in advance...

     

     
    • Post Points: 21

  • Wed, Dec 9 2009 10:38 AM In reply to

    Re: Named Cells

    Reply |Contact |Mark as Answer

    Try

     

    =IF(INDIRECT(A1&"DATE")>=C18,INDIRECT(A1&"PRE")/12,INDIRECT(A1&"POST")/12)/INDIRECT(A2&"Rate")

    Regards

    Bob

    • Post Points: 21

  • Mon, Feb 8 2010 7:51 AM In reply to

    Re: Named Cells

    Reply |Contact |Mark as Answer

    Thanks Bob
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.