Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula too long
How can I shorten this formula, I still need to add a few more variables and everytime I try and add one I get the formula is too long error. Thanks =IF(AND(A16="DeKalb",D16="Poncho 250"),0)+IF(AND(A16="DeKalb",D16="Cruiser Ext. Pak"),0)+IF(AND(A16="Dekalb",D16="Cruiser CRW"),48)+IF(AND(A16="DeKalb",D16="Poncho 1250"),48)+IF(AND(A16="Asgrow",D16="Poncho 250"),0)+IF(AND(A16="Asgrow",D16="Cruiser Ext. Pak"),0)+IF(AND(A16="Asgrow",D16="Cruiser CRW"),48)+IF(AND(A16="Asgrow",D16="Poncho 1250"),48)+IF(AND(A16="Croplan",D16="Poncho 250"),0)+IF(AND(A16="Croplan",D16="Cruiser Ext. Pak"),0)+IF(AND(A16="Croplan",D16="Cruiser CRW"),48)+IF(AND(A16="Croplan",D16="Poncho 1250"),48)+IF(AND(A16="Northrup King",D16="Poncho 250"),16)+IF(AND(A16="Northrup King",D16="Cruiser Ext. Pak"),16)+IF(AND(A16="Northrup King",D16="Cruiser CRW"),48)+IF(AND(A16="Northrup King",D16="Poncho 1250"),48)+IF(AND(A16="Mycogen",D16="Poncho 250"),16)+IF(AND(A16="Mycogen",D16="Cruiser Ext. Pak"),16)+IF(AND(A16="Mycogen",D16="Cruiser CRW"),48)+IF(AND(A16="Mycogen",D16="Poncho 1250"),48) -- cencoit ------------------------------------------------------------------------ cencoit's Profile: http://www.excelforum.com/member.php...o&userid=27378 View this thread: http://www.excelforum.com/showthread...hreadid=468987 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
Formula Too Long | Excel Discussion (Misc queries) | |||
long formula obscures cell view | Excel Discussion (Misc queries) | |||
Formula too long | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |