If Question

[iliaisyah]

Im using the expression as below

= If(PlantingMaterial='Socfindo',95) and its works

but i want to add, if other = 100

how to add the expression for that

total expression is if planting material is socfindo, score = 95, is planting material other than socfindo, score is 100

[madhu_r]

Hi,

Try this

= If(PlantingMaterial='Socfindo',95,If(PlantingMaterial='other',100))

Thanks & Regards,

Madhu

[pasi_lehtinen · Accepted solution]

= If(
    PlantingMaterial='Socfindo',
    95,
    if(
        PlantingMaterial='Other',
        100
    )
)

or

pick(match(PlantingMaterial,'Socfindo','Other'),95,100)

[iliaisyah]

Thank you it works!

[MindaugasBacius]

iliaisyah don't for get to close the thread by checking the correct answer.
Thank you!

[sergio0592 · Accepted solution]

Otherwise, you can use this syntax :

=pick(match(PlantingMaterial,'Socfindo')+1,100,95)

Here advantage is that it works even if you don't have  'other' value in your data.

[iliaisyah]

This also works!