=IF('Example import for Xero (002)'!E2<10,CONCATENATE('Example import for Xero (002)'!F2,"0",'Example import for Xero (002)'!E2),IF(AND('Example import for Xero (002)'!E2>10,'Example import for Xero (002)'!E2<50),CONCATENATE('Example import for Xero (002)'!F2,'Example import for Xero (002)'!E2)),If('Example import for Xero (002)'!E2=999,CONCATENATE('Example import for Xero (002)'!E2,J2)))
Solved by Z. F. in 23 mins