Newbie, interactive quizzes

[henrysun909]

Begging your indulgence:

I located a small worksheet for creating interactive quizzes in Excel. It includes two lines of code that are inserted as formulas:

=IF(questions!C3=score!a3,"Correct","try again"

and

=COUNTIF(C11:C21,"Correct")

I cannot locate the Calc equivalents of these formulas (the first is an Excel function of the form

IF(logical_test,value_if_true,value_if_false)

and the second is an Excel function of the form

COUNTIF(range,criteria)

Can anyone point me in the direction of equivalent formula programming for me? When I searched this forum, most of the interactive threads had to do with web interactivity, not spreadsheet interactivity.

Thanks in advance,

Henrysun909