IF FORMULAS

[pADDY qUIGLEY]

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

 

[Biff]

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

=10-C1

Biff

 

[Ragdyer]

One way:

Try this in D1:

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

 

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk

 

[pADDY qUIGLEY]

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]

Ok.....

In B1 enter this formula:

=10-A1

Biff

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

 

[robert111]

use a lookup table

 

[pADDY qUIGLEY]

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]

Try this:

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