View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default 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