| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula for a quiz in Excel?
I want to have a list of questions and when the answers are typed into
corresponding cells I want the following cell to say 'True' of "False'. How do I create the forumla? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula for a quiz in Excel?
=(C2=__Correct Answer__) assuming the answer is in C2.
This formula will produce the Excel logical values TRUE/FALSE. In the formula above, if __Correct Answer__ is expected to be text, enclose in double quotes. If it is supposed to be a number then no quotes. If you want to sum the TRUE answers, you might want to use =COUNTIF(E:E, TRUE) assuming that all formulas that return true/false are in column E:E. HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| how do i create a quiz using excel? | Excel Discussion (Misc queries) | |||
| Can I create a formula in Excel that evaluates form information? | Excel Worksheet Functions | |||
| Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Linear Mode
