=LOOKUP(B2,{"a","b","c"},{10,28,6})



--
Don Guillett
SalesAid Software

"PowerPointless" wrote in message
...
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.