ExcelBanter - Greater of Two Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Greater of Two Cells (https://www.excelbanter.com/excel-worksheet-functions/152590-re-greater-two-cells.html)

Simon y Glog

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

All times are GMT +1. The time now is 08:29 PM.