easy peasy

Basically i need a little bit of an equation that does the folowing:

if number is 24 then add 13
if number is 23 then add 14
if number is 22 then add 15
if number is 21 then add 16
if number is 20 then add 17
...
...
if number is 14 then add 23
if number is 13 then add 24

can anyone see a one line soution (or near as dammit) to this???

thanks

Code:

---

If Number >= 13 AndAlso Number <= 24 Then Number = 37

---

Uhh.... 24 + X = 37... thus

37 - 24 = X

so

37 - YourInputNumber = YourOutputNumber

Quote:

---

Originally Posted by Jenner

Uhh.... 24 + X = 37... thus

37 - 24 = X

so

37 - YourInputNumber = YourOutputNumber

---

Instead of doing all that math (which isn't much, I know) why not just check the value of 'Number' and if it's between the certain range, just make it 37

If Number is between (or equal to) 13 and 24, then make it equal to 37

Quote:

---

Originally Posted by JuggaloBrotha

Instead of doing all that math (which isn't much, I know) why not just check the value of 'Number' and if it's between the certain range, just make it 37

If Number is between (or equal to) 13 and 24, then make it equal to 37

---

I think by his question he's looking for what the number is needed to add to the first number. He has 24, puts it into the function, he's returned 13... that's how I read it. He listed it out as an example.

Thus:

Code:

---

intNumberOut = 37 - intNumberIn

---

Quote:

---

Originally Posted by Jenner

I think by his question he's looking for what the number is needed to add to the first number. He has 24, puts it into the function, he's returned 13... that's how I read it. He listed it out as an example.

Thus:

Code:

---

intNumberOut = 37 - intNumberIn

---

---

In that case, yes a function would serve nicely. I read his post as:

If Number = 24 then add 13, so Number = 37
If Number = 23 then add 14, so Number = 37
If Number = 22 then add 15, so Number = 37

In which case, the end result is always Number = 37

Sorry guys i dont mean add the number to itself i mean add the number to a different variable, but not so the total is always the same...

Do you mean something like this?:confused: :confused: :confused:

Code:

---

            Dim i, num1, num2 As Integer
            num1 = 24
            num2 = 13
            For i = 1 To 24
                num1 -= 1
                num2 += 1
                Me.Text = num1 & " " & num2
            Next

---

From your original post, it seems that the sum is always 37... Now that you've said the total is not always the same, I think you need to give us more details.

Something like this:

Code:

---

OtherNumber += CalcNumber(Number)


Private Function CalcNumber(Byval OriginalNumber As Integer) As Integer
  If OriginalNumber >= 13 AndAlso OriginalNumber <= 24 Then
    Return 37I - OriginalNumber
  Else
    Return 0I
  End If
End Function

---

I'm totally and utterly confused at this point.