Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested formula trouble
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested formula trouble
Whay you're doing wrong is forgetting quotes where you need them, around
text strings (because a, b, and c weren't defined as names), and putting quotes where you don't want them, around your second IF statement. Try =IF(B2="a",10,IF(B2="b",8,IF(B2="c",6))) You may also want to define what you want as a result if B2 is other than a, b, or c. -- David Biddulph "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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested formula trouble
Hello,
=IF(B2=a,10,"IF(B2=b,8,IF(B2=c,6)))") You do not identify your strings/characters to Excel correctly. Try =IF(B2="a",10,IF(B2="b",8,IF(B2="c",6))) Or =INDEX({10,8,6},MATCH(B2,{"a","b","c"},FALSE)) Regards, Bernd |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested formula trouble
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formula trouble. | Excel Worksheet Functions | |||
Trouble with condition nested formula | New Users to Excel | |||
I'm new at this - having trouble with a formula | Excel Discussion (Misc queries) | |||
Trouble with nested IF formula | Excel Worksheet Functions | |||
Formula Trouble | Excel Worksheet Functions |