Formula explaination
As written, the R:R+ does nothing. The R:R refers to the entire column R and
the plus is just a plus (addition symbol). It has the ultimate effect of
adding 0 to your Maximum number.
Where you'd use R:R would be inside a function that calls for a range. Such
as SUM(R:R) would give you the sum of all numbers in column R.
HTH,
Elkar
"r" wrote:
A person typed some numbers in column A (line 2 to line 10)
then in line 12 she wanted to show the maximum number in the column
to show that value, the only formula I know is .. =MAX(B6:B30)
However, she used the following formula:
=R:R+MAX(B6:B30)
can any one tell me what the "R:R" stands for? and why there is a plus mark?
Thank you
|