Hi all. I have a strange question, in the sense that I myself don't know exactly what I have to ask; so please be patient. The general subject is Array formulas (which btw I have just begun using).
---
I put this in the cell G5:
=D5:D7*E5:E7
then I select the cells G5:G7, press F2, then shift+ctrl+enter and I get the array formula.
{=D5:D7*E5:E7}
---
I'd like to know if it's possible (and how) to use a function of mine instead of a built-in function like *. Maybe it's a silly question, but I wasn't able to understand it by my own. For instance, I tried to write a function which performs the same task of the formula above:
When I build the array formula, all the cells G5:G7 show the result of the cell G5. I don't know how to determine the address of each cell of the array and to return the corresponding result. If I change that function (just in the attempt to understand something) in
the function returns the same total range in each row.
$G$5:$G$7
$G$5:$G$7
$G$5:$G$7
Does my question make sense?
Antonio
Bookmarks