ID : 3834

Max

Function

To return a maximum value.

Syntax

Max(formula, formula[, formula])

Guaranteed Entry

Formula: Lay formulas you want to compare values in separated by a comma (,). Designate double precision real number type data. Up to 32 arguments can be designated.

Return Value

Return the largest value among the designated formulas by double precision real number type data.

Description

The largest value among the specified number of formulas is returned by double precision real number type data.

The maximum number of formulas that can be specified is 32.

Related Terms

Min

Attention

Example

'!TITLE "Extraction of Maximum Value"
' Assign the maximum value to aaa
Sub Sample_Max

  Dim aaa As Integer
  Dim bbb As Integer
  Dim ccc As Integer
  Dim ddd As Integer
  Dim eee As Integer

  bbb = 4
  ccc = 2
  ddd = 10
  eee = 8

  ' Enter the largest value between bbb and eee in aaa.
  aaa = Max( bbb, ccc, ddd, eee )

  ' Display "10" on the message output window
  PrintDbg aaa

End Sub

ID : 3834

<< Prev Next >>