Excel interface

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

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)

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