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
Posted by Mark W. on January 11, 2001 3:30 AM
=INDIRECT("D"&C3+1)
Posted by Yin Mi Zhi on January 11, 2001 10:18 PM
Duo xie, many thanks.
