If statement syntax

[CreepyCatLady]

Hi all. I am very confused. I keep getting an error in the expression editor on the nested if statement below, and I can't figure out what is wrong with it. It says ")" expected, but all my parenthesis are closed.

=IF(HARDWARE_VENDOR_NAME='APPLE','Apple'&' '&HOST_DEVICE_TYPE_FULL&'-'&REGION,
if(HARDWARE_VENDOR_NAME='MICROSOFT' AND REGION-='ABCD', 'Microsoft'&' '&HOST_DEVICE_TYPE_FULL&'-'&REGION))

Can anyone tell me where the problem is? Thanks so much!

[Saravanan_Desingh · Accepted solution]

REGION-='ABCD'

This is not allowed. This is Set Analysis Syntax.

Try this,

=If(Match(HARDWARE_VENDOR_NAME,'APPLE','Apple'&' '&HOST_DEVICE_TYPE_FULL&'-'&REGION),
If(HARDWARE_VENDOR_NAME='MICROSOFT' AND REGION<>'ABCD', 'Microsoft'&' '&HOST_DEVICE_TYPE_FULL&'-'&REGION
)
)

[CreepyCatLady]

Oh my goodness this was it! Thank you so much!