Hi, people...this is the second time I post this because the other one didn't
go through. I've added this formula to an Excel table:

=IF(B2=a,10,"IF(B2=b,8,IF(B2=c,6)))")

According to the nested-formula rules, this formula is well-formatted. It's
to calculate the points one gets when assigned a particular letter-grade (A
thru C).

HOWEVER, though I don't get an actual error message, the cell where the
result should appear only reads this:

#NAME?

Can someone please tell me what I'm doing wrong? Much appreciated.