"Calcutable" reference

  • Thread starter Gilbert De Ceulaer
  • Start date
G

Gilbert De Ceulaer

Hi,
Does anybody know a way (with functions, please) to get the value stored in
a place that can be calculated.
I mean : if A1 contains "ABCDE", what can I enter in A7, using the
difference (6, 13-7, 12/2, 3*4,...) as an argument..
This would help me a lot.
Thanks in advance,
Gilbert
 
D

dvt

Gilbert said:
Hi,
Does anybody know a way (with functions, please) to get the value
stored in a place that can be calculated.
I mean : if A1 contains "ABCDE", what can I enter in A7, using the
difference (6, 13-7, 12/2, 3*4,...) as an argument..
This would help me a lot.
Thanks in advance,
Gilbert

I'm not at all sure what your question means. Have you tried the OFFSET and
INDEX functions? You might need to throw in an INDIRECT function as well...

Dave
dvt at psu dot edu
 
B

Biff

Hi Gilbert,

To be used as an argument for what? How? You can use
something along the lines of INDIRECT or OFFSET and maybe
INDEX. Need more specific info.

Biff
 
G

Gilbert De Ceulaer

Hi,
Thank you my friends, I found it myself. It is (if one wants to put the
value of D75 in D81) :
INDIRECT("R["&-12/3&"]C"&COLUMN(D81);FALSE)
If you know of a simpler way to get it, please let me know.
Regards,
Gilbert
 
D

dvt

Gilbert said:
Hi,
Thank you my friends, I found it myself. It is (if one wants to put
the value of D75 in D81) :
INDIRECT("R["&-12/3&"]C"&COLUMN(D81);FALSE)
If you know of a simpler way to get it, please let me know.
Regards,
Gilbert

Seems to me that you could put this formula in D81:
=D75

That seems a little simpler.

Dave
dvt at psu dot edu
 
G

Gilbert De Ceulaer

Dear Dave,

I'll be more elaborate :

If the months are in the A-column
If somebody has to pay something X times/year (X being 1, 2, 3, 4, 6 or 12)
If the previous time appears in D75
If I do not want to show something in the other months
Then I put in D76-D86 :
if(month(A76 till A86)=month(A$75)+12/X;
INDIRECT("R["&-12/X&"]C"&COLUMN(D76 till 86);FALSE) ;"")

Sorry for the akward way of explaining, but English is not my first
language, and neighter is "Excel".

If you know of a simpler way to do this, please let me know.

Regards,
Gilbert
 
D

dvt

Gilbert said:
Dear Dave,

I'll be more elaborate :

If the months are in the A-column
If somebody has to pay something X times/year (X being 1, 2, 3, 4, 6
or 12) If the previous time appears in D75
If I do not want to show something in the other months
Then I put in D76-D86 :
if(month(A76 till A86)=month(A$75)+12/X;
INDIRECT("R["&-12/X&"]C"&COLUMN(D76 till 86);FALSE) ;"")

Sorry for the akward way of explaining, but English is not my first
language, and neighter is "Excel".

If you know of a simpler way to do this, please let me know.

Regards,
Gilbert

Sounds to me like you found a pretty good solution. Nice work.

Dave
dvt at psu dot edu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top