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&'-'®ION, if(HARDWARE_VENDOR_NAME='MICROSOFT' AND REGION-='ABCD', 'Microsoft'&' '&HOST_DEVICE_TYPE_FULL&'-'®ION))
Can anyone tell me where the problem is? Thanks so much!