| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
What is wrong with the function?
=IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z"))))) Thank you for your help! Karen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
You need to put quotes around the letters, like this:
=IF(H55="A","2",IF(H55="B","4",IF(H55="C","6",IF(H 55="D","8",IF(H55="E","10","Z"))))) However, you might NOT need the quotes around the numbers, as they will become text values. Hope this helps. Pete On Aug 13, 2:23*pm, KAY wrote: What is wrong with the function? =IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z"))))) Thank you for your help! Karen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Try this alternative for your intents:
=IF(H55="","",IF(ISNUMBER(MATCH(H55,{"A";"B";"C";" D";"E"},0)),VLOOKUP(H55,{"A",2;"B",4;"C",6;"D",8;" E",10},2,0),"Z")) In your posted formula, text (eg: "A", "B") should appear within double quotes, numbers without. You had it mixed up. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "KAY" wrote: What is wrong with the function? =IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z"))))) Thank you for your help! Karen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
You have it backwards.
"A" 2 -- Don Guillett Microsoft MVP Excel SalesAid Software "KAY" wrote in message ... What is wrong with the function? =IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z"))))) Thank you for your help! Karen |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
KAY wrote:
What is wrong with the function? =IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z"))))) Thank you for your help! Karen My guess is you would want A, B, C, D and E in quotes and 2, 4, 6, 8 and 10 not in quotes. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
=IF(CODE(UPPER(H55))69,"Z",(CODE(UPPER(H55))-64)*2)
"KAY" wrote: What is wrong with the function? =IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z"))))) Thank you for your help! Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
