Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
REGION-='ABCD'
This is not allowed. This is Set Analysis Syntax.
Try this,
=If(Match(HARDWARE_VENDOR_NAME,'APPLE','Apple'&' '&HOST_DEVICE_TYPE_FULL&'-'®ION),
If(HARDWARE_VENDOR_NAME='MICROSOFT' AND REGION<>'ABCD', 'Microsoft'&' '&HOST_DEVICE_TYPE_FULL&'-'®ION
)
)
REGION-='ABCD'
This is not allowed. This is Set Analysis Syntax.
Try this,
=If(Match(HARDWARE_VENDOR_NAME,'APPLE','Apple'&' '&HOST_DEVICE_TYPE_FULL&'-'®ION),
If(HARDWARE_VENDOR_NAME='MICROSOFT' AND REGION<>'ABCD', 'Microsoft'&' '&HOST_DEVICE_TYPE_FULL&'-'®ION
)
)
Oh my goodness this was it! Thank you so much!