New Contributor

# Adding many conditions in calculated value SP

Hello everyone,
I have a calculated value field and i want to look in a column1 and check for values and return OK or NOK, example :

IF(column1 contains 0% or 25% or 50% or 75%) if yes return "OK" if not "NOK.

Any ideas ?

3 Replies

# Re: Adding many conditions in calculated value SP

Hi @Georges - try something like this:

=IF([COLUMN 1]=0,"ok",IF([COLUMN 1]=25,"ok", IF([COLUMN 1]=50,"ok",IF([COLUMN 1]=75,"ok","nok"))))

# Re: Adding many conditions in calculated value SP

Hello @Kelly_Edinger

I did this formula :

=SI([Avancement :]=0%;"OK";SI([Avancement :]=25%;"OK";SI([Avancement :]=50%;"OK";SI([Avancement :]=75%;"OK";SI([Avancement :]=100%;"OK";[Avancement :])))))

and the result is the opposite.

I want to look in the Column "Avancement" and the result in "Statut simplifié".

Thank you

# Re: Adding many conditions in calculated value SP

@Georges it doesn't look like your last IF statement isn't complete, your example shows the formula ending with ;[Avancement :] and it should end with the value to display if the statement is not true.

I also see semi-colons instead of commas. Try this:

=IF([Avancement :]=0,"ok",IF([Avancement :]=25,"ok", IF([Avancement :]=50,"ok",IF([Avancement :]=75,"ok","nok"))))