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.