Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with condition nested formula | New Users to Excel | |||
'IF' formula trouble | Excel Discussion (Misc queries) | |||
Trouble with an IF formula | Excel Worksheet Functions | |||
Trouble with nested IF formula | Excel Worksheet Functions | |||
Trouble with formula | Excel Discussion (Misc queries) |