[Solved] Need help please -error:508/#NAME

[hjnidgett]

I have a grade book that shows final grades as a column of percentages. I am trying to use an IF statement to display whether the student passes or fails. The fail if the logic test is below .7 and pass otherwise. Using the following formula:

=IF(P5<.7; then_fail; otherwise_pass)

I keep getting a Err:508 or an #NAME error.

What am I doing wrong and how do I correct it?

Thank you in advance.

[FJCC]

Text has to be enclosed in double quotes like this

Code: Select all

=IF(P5<.7; "then_fail"; "otherwise_pass")

or

Code: Select all

=IF(P5<.7; "fail"; "pass")

[hjnidgett]

Thank you so much, I tried the second one and it worked.