Variables IF code is not working

Forum|Forum|8 months ago
July 15, 2025
2 replies
322 views

Hi,

I'm using variables to change an image when a certain category is used. So if 'Finance' is used the image of 'taart' should be displayed.

My spreadsheet skills are limited but I came up with the code below. Somehow I get an error when using this code. I hope somebody in this community can figure what's wrong. Thanks.

=IF(C2="Ice Maker","\Users\rudispitzers\Documents\03_theorie\illustrator_2025\assets expert\ijsje.png",IF(C2=”Marketing","\Users\rudispitzers\Documents\03_theorie\illustrator_2025\assets expert\sorbet.png",IF(C2=”Finance","\Users\rudispitzers\Documents\03_theorie\illustrator_2025\assets expert\taart.png",IF(C2=”Management","\Users\rudispitzers\Documents\03_theorie\illustrator_2025/assets expert\soda.png"))))

How-to

Rudi SpitzersAuthor

Known Participant

I thought I found it. macOS needs a ; (semi colon) instead of a comma. But still I get an 'unknown error' in Illustrator.

CarlosCanto

Community Expert

I have no experience with Macs, your formula worked well on Windows once I replaced the curly quotes

Rudi SpitzersAuthor

Known Participant

The problem is that Illustrator can't find the path. I followed the instructions of the Adobe Help File but somehow the =IF formula doesn't work on a Mac. If it's just an image without the conditions it works fine.

CarlosCanto

Community Expert

you have "curly" quote marks at the beginning of Marketing, Finance and Management. Change those to "straight" quote marks

Rudi SpitzersAuthor

Known Participant

Thanks Carlos, I've tried straight ones but it still gives an error.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded