hi
how can i understand this line"
"=RAND()*(R2C2-R1C2)+R1C2"
and how i can adjust this formula to anther ranges?
thanks
hi
how can i understand this line"
"=RAND()*(R2C2-R1C2)+R1C2"
and how i can adjust this formula to anther ranges?
thanks
Last edited by Simon Lloyd; 07-08-2010 at 05:15 AM. Reason: Edited title to reflect content
This is just RC notation
R2C2 is euqivalent to $B$2, that is row 2, column 2, and absolute.
R[-2]C[-2] refers to the relative value of the cell tow rows above, two columns left.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber