Help with nested if/and formula

[Sara_Davis]

Hello Community!

I am trying to figure out the following with a nested IF formula- returning a value based on the name of the project. I have 8 different projects to categorize into one of 3 categories.

I keep getting an error message saying to check the formula - what am I doing wrong?
IF({Project}=”Hours”,“Personnel”,
IF({Project}=”Sales”,“Finance",
IF({Project}=”Marketing A”,“Finance”,
IF({Project}=”Marketing B”,“Finance”,
IF({Project}=”Expenses”,“Finance”,
IF({Project}=”Diversity”,“HR”,
IF({Project}=”Life Event”,“HR”,
IF({Project}=”Executive”,“HR”,"Unknown”))))))))

Thank you!

[kuovonne · Accepted solution]

Sara_Davis:

I keep getting an error message saying to check the formula - what am I doing wrong?

It could be a curly quote issue, or it could be something else.

I suggest using a SWITCH() instead.

SWITCH({Project},
  "Hours","Personnel",
  "Sales","Finance",
  "Marketing A","Finance",
  "Marketing B","Finance",
  "Expenses","Finance",
  "Diversity","HR",
  "Life Event","HR",
  "Executive","HR",
  "Unknown"
)

[Sara_Davis]

Thank you SO much!!! I realized it was a combination of formatting issues (curly quotes among others) and also this SWITCH formula made it so much easier.