Good day, i need help with this one.. i need a loop that will use the lower number inside an array if the
for example searchNumber = 9300 / result = 10000 but since it will return as negative result will use 7083
Code:
(searchNum - result) < 0 or negative
for example searchNumber = 9300 / result = 10000 but since it will return as negative result will use 7083
Code:
Dim numbers(), arrItem, maxItem, result, searchNum
'search number
searchNum = Cells(x, 3) - Cells(x, 4)
numbers = Array(1, 4167, 4583, 5417, 7083, 10000, 14583, 25000)
'get max of array item
maxItem = Application.Max(numbers)
'loop through each array item
For Each arrItem In numbers
If Abs(searchNum - arrItem) < maxItem Then
maxItem = Abs(searchNum - arrItem)
result = arrItem
If (searchNum - result) < 0 Then
'use lower number in array
End If
End If
Next arrItem