Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Can I use offset in formulas?

Posted by Yin Mi Zhi on January 11, 2001 1:56 AM

If I want to have a formula like =D(1+C3) where C3=5 giving the value in cell D6 how do I write this in Excel please.

Thank-you.

Yin

Re: Can I use offset in formulas?

Posted by Mark W. on January 11, 2001 3:30 AM

=INDIRECT("D"&C3+1)

Duo xie, many thanks.

Posted by Yin Mi Zhi on January 11, 2001 10:18 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.