C
cencoit
How can I shorten this formula, I still need to add a few more variable
and everytime I try and add one I get the formula is too long error.
Thanks
=IF(AND(A16="DeKalb",D16="Ponch
250"),0)+IF(AND(A16="DeKalb",D16="Cruiser Ext
Pak"),0)+IF(AND(A16="Dekalb",D16="Cruise
CRW"),48)+IF(AND(A16="DeKalb",D16="Ponch
1250"),48)+IF(AND(A16="Asgrow",D16="Ponch
250"),0)+IF(AND(A16="Asgrow",D16="Cruiser Ext
Pak"),0)+IF(AND(A16="Asgrow",D16="Cruise
CRW"),48)+IF(AND(A16="Asgrow",D16="Ponch
1250"),48)+IF(AND(A16="Croplan",D16="Ponch
250"),0)+IF(AND(A16="Croplan",D16="Cruiser Ext
Pak"),0)+IF(AND(A16="Croplan",D16="Cruise
CRW"),48)+IF(AND(A16="Croplan",D16="Ponch
1250"),48)+IF(AND(A16="Northrup King",D16="Ponch
250"),16)+IF(AND(A16="Northrup King",D16="Cruiser Ext
Pak"),16)+IF(AND(A16="Northrup King",D16="Cruise
CRW"),48)+IF(AND(A16="Northrup King",D16="Ponch
1250"),48)+IF(AND(A16="Mycogen",D16="Ponch
250"),16)+IF(AND(A16="Mycogen",D16="Cruiser Ext
Pak"),16)+IF(AND(A16="Mycogen",D16="Cruise
CRW"),48)+IF(AND(A16="Mycogen",D16="Poncho 1250"),48
and everytime I try and add one I get the formula is too long error.
Thanks
=IF(AND(A16="DeKalb",D16="Ponch
250"),0)+IF(AND(A16="DeKalb",D16="Cruiser Ext
Pak"),0)+IF(AND(A16="Dekalb",D16="Cruise
CRW"),48)+IF(AND(A16="DeKalb",D16="Ponch
1250"),48)+IF(AND(A16="Asgrow",D16="Ponch
250"),0)+IF(AND(A16="Asgrow",D16="Cruiser Ext
Pak"),0)+IF(AND(A16="Asgrow",D16="Cruise
CRW"),48)+IF(AND(A16="Asgrow",D16="Ponch
1250"),48)+IF(AND(A16="Croplan",D16="Ponch
250"),0)+IF(AND(A16="Croplan",D16="Cruiser Ext
Pak"),0)+IF(AND(A16="Croplan",D16="Cruise
CRW"),48)+IF(AND(A16="Croplan",D16="Ponch
1250"),48)+IF(AND(A16="Northrup King",D16="Ponch
250"),16)+IF(AND(A16="Northrup King",D16="Cruiser Ext
Pak"),16)+IF(AND(A16="Northrup King",D16="Cruise
CRW"),48)+IF(AND(A16="Northrup King",D16="Ponch
1250"),48)+IF(AND(A16="Mycogen",D16="Ponch
250"),16)+IF(AND(A16="Mycogen",D16="Cruiser Ext
Pak"),16)+IF(AND(A16="Mycogen",D16="Cruise
CRW"),48)+IF(AND(A16="Mycogen",D16="Poncho 1250"),48