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

Thanks! working!

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