Calculated Field in Pivot Table, Not Returning Correct If Function

Good Morning, For the last 2 days I have been trying to fix this formula but have been unable to do so, any help would be wonderful.

I am working on a Interview Report that basically says if they Pass of Fail the interview. Three supervisors are at the interview and they each score the interviewee if he/she makes over a score of 9 they get hired, under 9 they fail, over 12 they are over qualified, so this tells us if they are hiring the individual or not.

This is the Pivot Table:
Capture.JPG

The Sum of PassFail, is the Calculated Field, I can get the IF function to return the correct numbers but not the correct text.

Here is what I mean:

=IF(AND(SUM(Score)>=9), "9","0") <--This Works
=IF(AND(SUM(Score)>=9), "Pass","Fail") <--This doesn't work

I have tried different variations of the formulas but with the same results, here are the other formulas that I have tried.
=IF(L6>=9,"Pass","Fail") <--This doesn't work
=IF(AND(SUM(L6)>=9), "Pass","Fail") <--This doesn't work

Capture2.JPG

Any help would be amazing, thank you.

-Erik

Hello Erik

I don't believe you can return text like "Pass" or "Fail" into a Pivot's calculated field. You could try returning a number and custom formatting the cells to display text, for example the calculated field formula:

Formula:

Please Login or Register  to view this content.

Would return 1 or 0, you could then apply the following Custom cell format to the calculated field column:

Formula:

Please Login or Register  to view this content.

Hope this helps.
DBY

DBY, Thank you very much for your help. This is such an easy solution! I love it, This solved my issue.

Thanks again,

-Erik

Glad to have helped.