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.