"Calcutable" reference

  • Thread starter Thread starter Gilbert De Ceulaer
  • Start date 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
 
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
Click to expand...

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
 
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
 
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
 
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
Click to expand...

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

That seems a little simpler.

Dave
dvt at psu dot edu
 
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
 
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
Click to expand...

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

Dave
dvt at psu dot edu
 
Back
Top