Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with If Function
Can someone help me fix this because it doesn't seem to work and I don't know
where to go from here? =IF(A319&B317,"1",IF(A329&B3<17,"2",IF(A3<29&B3 17,"3",IF(A3<29&B3<17,"4")))) -- Thanks, Joy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with If Function
You need to tell us what you're trying to do.
=IF(AND(A319,B317),"1",IF(AND(A329,B3<17),"2",I F(AND(A3<29,B317),"3",IF(AND(A3<29,B3<17),"4")))) Regards, Paul -- "Joy" wrote in message ... Can someone help me fix this because it doesn't seem to work and I don't know where to go from here? =IF(A319&B317,"1",IF(A329&B3<17,"2",IF(A3<29&B3 17,"3",IF(A3<29&B3<17,"4")))) -- Thanks, Joy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with If Function
Maybe...
=IF(and(A319,B317),1,IF(and(A329,B3<17),2, IF(and(A3<29,B317),3,IF(and(A3<29,B3<17),4)))) But it looks like you're missing a value (when B3=17, for example). maybe... =IF(AND(A319,B317),1,IF(AND(A329,B3<17),2, IF(AND(A3<29,B317),3,IF(AND(A3<29,B3<17),4,"whatg oeshere")))) ps. I changed your text numbers to number numbers. Joy wrote: Can someone help me fix this because it doesn't seem to work and I don't know where to go from here? =IF(A319&B317,"1",IF(A329&B3<17,"2",IF(A3<29&B3 17,"3",IF(A3<29&B3<17,"4")))) -- Thanks, Joy -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with If Function
Hi Joy,
Paul & Dave have answered your question but I just thought I'd add an observation. As if the English language didn't have enough ambiguities, the Excel developers decided to add another. In English and = and & = and = ampersand + = and = plus = positive In Excel and = and & = and = ampersand + = and = plus = positive and AND < and, it = "x" and "x" A German friend of mine who is learning English has a very descriptive terminology for these ambiguities, however, I don't think it would be wise to share it on these forums. <g Regards Martin "Joy" wrote in message ... Can someone help me fix this because it doesn't seem to work and I don't know where to go from here? =IF(A319&B317,"1",IF(A329&B3<17,"2",IF(A3<29&B3 17,"3",IF(A3<29&B3<17,"4")))) -- Thanks, Joy |
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 |