IF not working in combination with OR

Hello guys! I have a working IF condition like thath:

IF(nume_client="-",nume_familie.ToUpper+space(1)+prenume.ToUpper,nume_client.ToUpper)

When I try to add several conditions with OR it gives me a compiler error: End of expression expected. Any ideas why?

This is how I tried, not working:

IF(OR(nume_client="-",nume_client=“nu am”,nume_client=“nu”),nume_familie.ToUpper+space(1)+prenume.ToUpper,nume_client.ToUpper)

Thanks!

Hi,

Or should be used between two expressions like this

expression1 Or expression2

Refer this link for more details about OR Operators and how to use it
https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/operators/or-operator

Thanks! working!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.