Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - returns name error
I want to use an IF statment in a spreadsheet as follows
Column I cells are Validated as Lists for input Column K is a value that is associated with Column I I want Column P to show me column K's value if Colmun I matches a certain selection from the list: When I input the statement: =IF(I2=ABCD,K2,0) I get an error of #Name? in P2 Can anyone explian why, and help me correct this please TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - returns name error
=IF(ISNUMBER(MATCH(I2,{"A";"B";"C";"D"},0)),K2,0)
HTH -- AP "Alan Davies" a écrit dans le message de news: ... I want to use an IF statment in a spreadsheet as follows Column I cells are Validated as Lists for input Column K is a value that is associated with Column I I want Column P to show me column K's value if Colmun I matches a certain selection from the list: When I input the statement: =IF(I2=ABCD,K2,0) I get an error of #Name? in P2 Can anyone explian why, and help me correct this please TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - returns name error
Hi
Try this, =IF(I2="ABCD",K2,0) With text you have to inclose it in qutation marks otherwise Excel thinks it is a name in the sheet and can't find it. Regards, Bondi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
VLOOKUP using a cell calculated with NOW returns Error | Excel Worksheet Functions | |||
error opening excel 2000 files | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |