Try this:

=IF(C1<"",CHOOSE(C1,9,10,11,12,13,14,15),0)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pADDY qUIGLEY" wrote in message
...
Thankyou very much indeed. Can you please help again?

I forgot to ask if C1 is left blank. How do I get d1 to show as a zero
score?

Once again many thanks for your info.

Paddy

"Ragdyer" wrote:

One way:

Try this in D1:

=CHOOSE(C1,9,10,11,12,13,14,15)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pADDY qUIGLEY" <pADDY wrote in
message
...
IF C1=1 THE D1 = 9, IF C1= 2 THEN D1 = 8, IF C1=3 THEN D1 =7 OAND SO
ON.