Multiple IF functions

Yusuf Safudien

Hello,

I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable.

=IF([ENM INITIATED]@row = 0; "Red"; "Yellow", IF([JOB STATUS]@row = "COMPLETED"; "Green"))

I would greatly appreciate your help.

Thank you

James Keuning

Put this:

IF([JOB STATUS]@row = "COMPLETED"; "Green";”Yellow”))

where you currently have "Yellow"

Yusuf Safudien

I've tried it, but it's still giving me the error. I'm not exactly sure if I structured it correctly. Could you possibly type out the entire function please?

Genevieve P.

Hi @Yusuf Safudien

I believe James was pointing out that the "Yellow" instruction would need to be at the very end, instead of in the middle.

This would be the full structure:

=IF([ENM INITIATED]@row = 0; "Red"; IF([JOB STATUS]@row = "COMPLETED"; "Green"; "Yellow"))

If this hasn't helped, it would be useful to see a screen capture of your sheet and a detailed instruction of when you want each colour to appear, but please block out sensitive data.

Cheers,

Genevieve