Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF function - limit to the number of IFs?
Is there a limit to the number of IF statements you can have in one function?
i.e. =IF(a1<a10,a10,(IF(a1<a11,a11,(IF(a1<a12,12,(IF(.. ................ and so on. I seem to get to 8 IFs and then get an error. |
#2
|
|||
|
|||
IF function - limit to the number of IFs?
That's it..........take a look at the VLOOKUP function.........
Vaya con Dios, Chuck, CABGx3 "jonrtait" wrote in message ... Is there a limit to the number of IF statements you can have in one function? i.e. =IF(a1<a10,a10,(IF(a1<a11,a11,(IF(a1<a12,12,(IF(.. ................ and so on. I seem to get to 8 IFs and then get an error. |
#3
|
|||
|
|||
IF function - limit to the number of IFs?
Thought so....
Only problem with the LOOKUP functions is that if an exact match is not found, the next largest value that is less than lookup_value is returned.... but I need the next largest value that is GREATER than the lookup_value.... Any thoughts? "CLR" wrote: That's it..........take a look at the VLOOKUP function......... Vaya con Dios, Chuck, CABGx3 "jonrtait" wrote in message ... Is there a limit to the number of IF statements you can have in one function? i.e. =IF(a1<a10,a10,(IF(a1<a11,a11,(IF(a1<a12,12,(IF(.. ................ and so on. I seem to get to 8 IFs and then get an error. |
#4
|
|||
|
|||
IF function - limit to the number of IFs?
If your data increments are equally spaced, like 100, 200, 300,
etc.........maybe something like..... =IF(ISNA((YourVlookupFormula,FALSE), (YourVLookupFormula+OneIncrement,True), (YourVlookupFormula,FALSE)) Vaya con Dios, Chuck, CABGx3 "jonrtait" wrote in message ... Thought so.... Only problem with the LOOKUP functions is that if an exact match is not found, the next largest value that is less than lookup_value is returned.... but I need the next largest value that is GREATER than the lookup_value.... Any thoughts? "CLR" wrote: That's it..........take a look at the VLOOKUP function......... Vaya con Dios, Chuck, CABGx3 "jonrtait" wrote in message ... Is there a limit to the number of IF statements you can have in one function? i.e. =IF(a1<a10,a10,(IF(a1<a11,a11,(IF(a1<a12,12,(IF(.. ................ and so on. I seem to get to 8 IFs and then get an error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
Function or number depending on input | Excel Worksheet Functions | |||
Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
Limit to the number of items in a cell | Excel Worksheet Functions | |||
How do I limit the number of complete sentences in a spreadsheet c | Excel Worksheet Functions |