• Home
 · 
• Math/Dates
 · 
• Compares numbers are returns the larger, smaller or difference value

Compares numbers are returns the larger, smaller or difference value

Compares numbers are returns the larger, smaller or difference value

API Declarations


rtpReturnLarger
rtpReturnSmaller
rtpReturnDifference
End Enum



Rate Compares numbers are returns the larger, smaller or difference value

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

'if just the difference is required then get it and exit
If ReturnPreference = rtpReturnDifference Then
   CompareNums = Abs(FirstNum - SecondNum)
   Exit Function
End If
'compare the nums
    If FirstNum > SecondNum Then
       'return according to the user's liking
      If ReturnPreference = rtpReturnLarger Then
        CompareNums = FirstNum
      ElseIf ReturnPreference = rtpReturnSmaller Then
        CompareNums = SecondNum
      End If
    ElseIf FirstNum < SecondNum Then
       'return according to the user's liking
      If ReturnPreference = rtpReturnLarger Then
        CompareNums = SecondNum
      ElseIf ReturnPreference = rtpReturnSmaller Then
        CompareNums = FirstNum
      End If
    Else 'the numbers are equal just return any
      CompareNums = FirstNum
    End If
End Function