Adding many conditions in calculated value SP

New Contributor

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

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

 

see more here: https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a

Hello @Kelly E 

 

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.

Status.PNG

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

Thank you

@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"))))