Author Topic: Excel interface  (Read 1230 times)

Tags:
  • All members
  • Posts: 231
  • Gender: Male
Excel interface
« on: 11 Sep 2018, 13:24 »
In my Excel spreadsheet created for each race, I have the following formula:

=IF(AND(silk_form_1>0,silk_form_1<10),silk_form_1,10)

ie if silk_form_1 is not between 1 and 9 (inclusive), the value should be 10.

However, if silk_form_1 is not a number, I get the #NAME error message.

Can someone tell me how to adjust this formula to show 10 when silk_form_1 is P, or x, or any other alphabetical symbol please?

Thanks,

bobh


  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: Excel interface
« Reply #1 on: 23 Sep 2018, 09:24 »
Hello!

Try this:

=IF(AND(IF(LEN(T(silk_form_1))=0, VALUE(silk_form_1), 0)>0,IF(LEN(T(silk_form_1))=0, VALUE(silk_form_1), 0)<10),IF(LEN(T(silk_form_1))=0, VALUE(silk_form_1), 0),10)
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • All members
  • Posts: 231
  • Gender: Male
Re: Excel interface
« Reply #2 on: 24 Sep 2018, 23:05 »
Thanks Oxa,

I thought I was OK at Excel, but that formula solution was totally beyond my ability.

I'm sure it will work, so much appreciated.

bobh

 

Please note, BetFair is seems to be currently OFFLINE