Multiple TRUE Values for one IF

Hello All,

I have this formula :

Please Login or Register  to view this content.

But I want to add also "05" as value for "Fast", so values for "Fast" will become "00" and "05".

Could you please give some assist ?


Best regards

Maybe this?

=IF(F3="";"";IF(OR(MID(F3;1;2)="00";MID(F3;1;2)="05");"Fast";"Slow"))

Beth

How about
=IF(F3="";"";IF(or(MID(F3;1;2)={"00";"05"});"Fast";"Slow"))

Thanks Beth,

I was facing the issue because of usage =IF(F3="";"";IF(OR(MID(F3;1;2)="00",MID(F3;1;2)="05");"Fast";"Slow"))

Thanks for the assistance ! Works like a charm !

Best regards,

Thanks fluff.

You're welcome & thanks for the feedback