View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PowerPointless PowerPointless is offline
external usenet poster
 
Posts: 4
Default Nested formula trouble.

Hi, oh mighty ones!

I'm trying to enter this formula in Excel:

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

According to the nested formulas rule, it's well-formatted (and I'm not even
using the seven-limit). This is to calculate how many points one gets
according to each school grade, A, B or C. HOWEVER...though it doesn't give
me an actual error message, the formula result cell tells me this:

#NAME?

Can someone tell me what I'm doing wrong? Thanks...