Is there a smart way to do this simple number pattern? Topic is solved

[blad4]

When I add 6 to A (starting at 1), I want B (starting at 463) to increase by 1.

I've always done it like below... yes that's how much I cannot code. Just wondering if there's a better way

Code: Select all

if A=1
B=463
if A=7
B=464
if A=13
B=465
if A=19
B=466
if A=25
B=467

[ntepa]

maybe like this:

Code: Select all

MsgBox "A=1 B=" Convert(1)
MsgBox "A=7 B=" Convert(7)
MsgBox "A=13 B=" Convert(13)
MsgBox "A=19 B=" Convert(19)
MsgBox "A=25 B=" Convert(25)

Convert(num) {
    return 463 + (num // 6)
}

[blad4]

Thanks so much for the help. I have been trying to get it, is this function from python?

Could you help me in simplifying it this way:

Code: Select all

B=463+(%A%//6)

Because then I could send that, and it would give me the answer stored in B which I can then manipulate the other ways I need to?

[ntepa]

is this function from python?

I made it up.

%% is not needed.

Code: Select all

A := 7
B := 463+(A// 6)

[blad4]

Perfect thank you