Pages:
Actions
  • #1 by keith31 on 17 Jul 2018
  • Hi,
    Would anybody mind simplifying the following, i have searched excel and cant see the answer.
    So, first three bets = initial bet, e.g. 2.
    Next three = 4, next three = 8, and so on.
    I have;  IF(losses=4, multiplier1a, IF(losses=5, multiplier1b, IF(losses=6, multiplier1c, IF(losses=7, multiplier2a, IF(losses=8, multiplier2b, IF(losses=9, multiplier2c, IF(losses=10, mutiplier3a,)))))))

    Where multiplier 1a, 1b, 1c, =4
    multiplier 2a, 2b, 2c =8, etc

  • #2 by Wez on 17 Jul 2018
  • Hi Keith,

    if the question is related to excel itself, try using the "Choose" formula.

    If cell A1 contains the variable "losses" then

    =CHOOSE(A1,2,2,2,4,4,4,8,8,8,16,16,16)

    will yield 2 for 1,2,3; 4 for 4,5,6; 8 for 7,8,9; etc.

    You can put error protection around this by using Choose within an IF statement or IFERROR

    e.g. Your "Stake" cell could say =If(losses <=12, CHOOSE(A1,2,2,2,4,4,4,8,8,8,16,16,16), 2)

    regards

    Wez
  • #3 by keith31 on 19 Jul 2018
  • Hi, Wez,

    Cant get it to work, fella, but thanks anyway!
  • #4 by mcbee on 19 Jul 2018
  • hi
    try.
    IF(AND(losses>=4,losses<=6),multiplier1a,IF(AND(losses>=7,losses<=9),multiplier2a,IF(AND(losses>=10,losses<=12),multiplier3a,initial bet)))

    using the AND reduces the length of the formulae

    mcbee
  • #5 by keith31 on 19 Jul 2018
  • Hi Mcbee.

    Thanks, but no luck.
    "Error in trigger expression"
  • #6 by keith31 on 19 Jul 2018
  • Hi again,

    Got it to work.
    Thanks again, so far, so good
Pages:
Actions