IF C1=1 THE D1 = 9, IF C1= 2 THEN D1 = 8, IF C1=3 THEN D1 =7 OAND SO ON.

Maybe this but it depends on how many "and so ons" you have.

=10-C1

Biff

"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.

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.

If the sequence carries on in the same way then will this do what you want?

=10-C1
--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"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.

Sorry,

if a1 = 1 then b1 = 9, if a1 =2 then b1 = 8, if a1 = 3 then b1 = 7, if a1 =
4 then b1 =6, if a1 = 5 then b1 = 5, if a1 = 6 then b1 = 4, if a1 = 7 then b1
= 3, if a1 = 8 then b1 = 2, if a1 = 9 then b1 = 1. it's points for positions
in a compition.

Many thanks for your help

Paddy

"Biff" wrote:

Maybe this but it depends on how many "and so ons" you have.

=10-C1

Biff

"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.

Ok.....

In B1 enter this formula:

=10-A1

Biff

"pADDY qUIGLEY" wrote in message
...
Sorry,

if a1 = 1 then b1 = 9, if a1 =2 then b1 = 8, if a1 = 3 then b1 = 7, if a1
=
4 then b1 =6, if a1 = 5 then b1 = 5, if a1 = 6 then b1 = 4, if a1 = 7 then
b1
= 3, if a1 = 8 then b1 = 2, if a1 = 9 then b1 = 1. it's points for
positions
in a compition.

Many thanks for your help

Paddy

"Biff" wrote:

Maybe this but it depends on how many "and so ons" you have.

=10-C1

Biff

"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.

use a lookup table


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=561209

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.

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.