Excel MAX Function
Use:- Computes largest value in a set of data
- Syntax:
- MAX( range )
- Examples:
- Cell D12 formula: MAX( C4:G4 )
Cell D13 formula: MAX( D3:D9 )
Cell D14 formula: MAX( C3:G9 )
Cell D15 formula: MAX( D3:D9,G3:G9 ) 
- Related Functions:
- MIN, LARGE, SMALL,
RANK