Author Topic: simplify please  (Read 1273 times)

Tags:
  • All members
  • Posts: 107
simplify please
« on: 17 Jul 2018, 18:30 »
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


  • All members
  • Posts: 154
  • Gender: Male
Re: simplify please
« Reply #1 on: 17 Jul 2018, 21:46 »
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

  • All members
  • Posts: 107
Re: simplify please
« Reply #2 on: 19 Jul 2018, 17:04 »
Hi, Wez,

Cant get it to work, fella, but thanks anyway!

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: simplify please
« Reply #3 on: 19 Jul 2018, 17:35 »
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
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 107
Re: simplify please
« Reply #4 on: 19 Jul 2018, 18:55 »
Hi Mcbee.

Thanks, but no luck.
"Error in trigger expression"

  • All members
  • Posts: 107
Re: simplify please
« Reply #5 on: 19 Jul 2018, 19:00 »
Hi again,

Got it to work.
Thanks again, so far, so good

 

Please note, BetFair is seems to be currently OFFLINE