alliebobz
09-26-2008, 06:00 PM
...Formula)? I am trying to create a quiz using Excel.
The premise for the quiz is naming the song and artist of lyrics that I have set down.
Obviously bands cover songs, so I want to allow for this.
I am using the IF formula:
=IF(D36="Jeff Buckley", "Correct", "Wrong")
However, I also want to allow for the answer Leonard Cohen. How do I express this as a formula?
Thanks :)
The premise for the quiz is naming the song and artist of lyrics that I have set down.
Obviously bands cover songs, so I want to allow for this.
I am using the IF formula:
=IF(D36="Jeff Buckley", "Correct", "Wrong")
However, I also want to allow for the answer Leonard Cohen. How do I express this as a formula?
Thanks :)