- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Formula explaination

Subject: | Formula explaination |

Posted by: | r |

Date: | Mon, 15 May 2006 |

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

- RE: Formula explaination posted by Elkar on Mon, 15 May 2006
- Re: Formula explaination posted by Niek Otten on Mon, 15 May 2006