View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon y Glog Simon y Glog is offline
external usenet poster
 
Posts: 3
Default Greater of Two Cells

Simple when you know how!!!!!

Many thanks, PCLIVE

"PCLIVE" wrote:

=MAX(A1:A2)

"Simon y Glog" <Simon y wrote in message
...
Guys -

I want a function to return the greater value of two cells. How do I do it
please?

For example, cell A1 contains the number 1.
Cell A2 contains the number 2.
Cell A3 contains the function which will return "2"

Thanks in advance for your efforts