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? |
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 |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com