4. You will notice that you need to enclose your formula by double quotes and that you need to replace each " (double quote) by two "" (two double quotes).
5. This VBA approach is my preferred one.
6. But if you are not allowed to use VBA then let us go with a "worksheet formula"-only approach which makes use of the Excel4 macro command Evaluate.
7. Define a name EvaluateLockedFormula which refers to