IF formula help resquested !

Bridor

I'm trying to to create a formula that turns in a number the text in a row.

this formlu is working :

=IF(FREQUENCE@row = "Probable FREQUENT"; 5)

but when I try to add other text it just doesn't work.

I would like to create a formula that gives me these numbers in these conditions :

• Probable FREQUENT = 5
• Probable MENSUEL = 4
• Probable ANNUEL = 3
• RARE = 2
• IMPROBABLE = 1

Nic Larsen

Should be:

=IF(FREQUENCE@row = "Probable FREQUENT"; 5; IF(FREQUENCE@row = "Probable MENSUEL"; 4; IF(FREQUENCE@row = "Probable ANNUEL"; 3; IF(FREQUENCE@row = "RARE"; 2; 1)

Nic Larsen

Should be:

=IF(FREQUENCE@row = "Probable FREQUENT"; 5; IF(FREQUENCE@row = "Probable MENSUEL"; 4; IF(FREQUENCE@row = "Probable ANNUEL"; 3; IF(FREQUENCE@row = "RARE"; 2; 1)

Bridor

Nic you are my "wow" of the day!

thanks for taking the time

Pat