Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Results of Answers for a Quiz
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do you send results of calc to seperate rows of answers to then later create chart | Excel Discussion (Misc queries) | |||
Hiding results | Excel Discussion (Misc queries) | |||
hiding blank cells when no results | Excel Worksheet Functions | |||
Correct answers like a quiz | Excel Worksheet Functions | |||
Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) |