Pages:
Actions
  • #1 by bobh on 11 Sep 2018
  • 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

  • #2 by Oxa (WellDoneSoft) on 23 Sep 2018
  • 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)
  • #3 by bobh on 25 Sep 2018
  • 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
Pages:
Actions