Stop formula calculations once conditions are met

[waddsn1060]

I need a script that once a condition is met in 2 cells that the formulas will stop calculating on another sheet and change the values to text.

On the attached sheet, once the patient ID on the sheets Form and Table1 match, and the user has entered Yes in the Completed box in cell G6 on the Form sheet, I want the formulas in columns L through R on the Table1 sheet to stop calculating and change the values to text.

Is this possible?

Thanks in advance.