bebo91

The operations run with no issues, the issues as you said its “equation error”
the == has fixed some of the errors, out of 34 fields, i still got 2 which contains ROUNDUP function return no results
The equation itself runs perfectly on google sheets, so its just switching to JS errors

IF(OR(fieldname2=="",fieldname3=="",fieldname4=="",fieldname8==""),"",IF(AND(OR(fieldname5=="小号标准尺寸",fieldname5=="大号标准尺寸"),(fieldname10+fieldname13)<1),ROUNDUP((fieldname10+fieldname13)*16,0),IF(fieldname10<1,ROUNDUP((fieldname10+fieldname13),0),ROUNDUP(IF(fieldname10>fieldname14,fieldname10,fieldname14)+fieldname13,0))))

IF(OR(fieldname2==””,fieldname3==””,fieldname4=””,fieldname8==””),””,IF(AND(fieldname5==”小号标准尺寸”,fieldname15<=6),2.7,IF(AND(fieldname5==”小号标准尺寸”,fieldname15>6,fieldname15<=12),2.84,IF(AND(fieldname5==”大号标准尺寸”,(fieldname10+fieldname13)<1,fieldname15<=6),3.47,IF(AND(fieldname5==”大号标准尺寸”,(fieldname10+fieldname13)<1,fieldname15>6,fieldname15<=12),3.64,IF(AND(fieldname5==”大号标准尺寸”,(fieldname10+fieldname13)>1,fieldname15>12,fieldname15<=16),4.25,IF(AND(fieldname5==”大号标准尺寸”,(fieldname10+fieldname13)>1,fieldname15>1,fieldname15<=2),4.95,IF(AND(fieldname5==”大号标准尺寸”,(fieldname10+fieldname13)>1,fieldname15>2,fieldname15<=3),5.68,IF(AND(fieldname5==”大号标准尺寸”,(fieldname10+fieldname13)>1,fieldname15>3,fieldname15<=20),(5.68+0.3*(fieldname15-3)),IF(fieldname5==”小号大件”,(8.66+0.38*(fieldname15-2)),IF(fieldname5==”中号大件”,(11.37+0.39*(fieldname15-2)),IF(fieldname5==”大号大件”,(76.57+0.79*(fieldname15-90)),IF(fieldname5==”特殊大件”,(138.11+0.79*(fieldname15-90)),0)))))))))))))

• This reply was modified 3 years, 6 months ago by bebo91. Reason: Equation into code format