Hi,

Looking for some help here please.

I currently have a quiz set up, with simple questions in the A Column.

The delegate places their answer in the B Column, and the C Column then
states whether it is correct or not.

Used the following formula :
=IF(B2="A","CORRECT",IF(B2="","",IF(B2="B","INCORR ECT")))

What I need, is for the formula to only be applied once the delegate
indicates that they are finished the whole test. (i.e. clicks a cell marked
as a "Finished" button).

I need to know 2 things:

1. How to set up a cell like a "finished" button for example.
2. How to get the formula not to apply until the finished button has been
selected.

Any help would be greatly appreciated!!

Thanks!