#UNPARSEABLE is returned...Even though the formula seems correct

Marcel Hovsepian

Hello,

I have looked through Q&A and went through formulas tutorials. My formula appears correct to me but keeps on returning #UNPARSEABLE in my Project Health column.

Any help or if someone can point out what might be happening, it would be greatly appreciated.

Paul Newcome

Try removing the cell references and actually clicking on the correct cell.

Paul Newcome

Try removing the cell references and actually clicking on the correct cell.

Marcel Hovsepian

Thank you Paul,

The solution worked.

Much appreciated,

Marcel

Paul Newcome

Happy to help. 👍️