views:

32

answers:

2

In Excel, is there a native function that will return the larger of two values? I'm looking to avoid using the IF function. I'm using Excel 2010 Beta if that's worth anything.

For example: GTR(66,24) will return 66.

+3  A: 

Try MAX(Cell1, Cell2)

Michael Bray
+2  A: 

Have a look at Max

The MAX function, one of Excel's statistical functions, is used to find the largest or maximum number in a given list of values or arguments.

=MAX( argument1, argument2, ... argument30 ) 
astander