The Ship or Hold decision is based on a complex set of rules in this order:? If Fuel & Maintenance Ready is FALSE, then the status is "HOLD".? If Fuel and Maintenance Ready, and "Capacity Achieved" Then SHIP.? If a truck/trailer is Fuel and Maintenance Ready, but Capacity is not achieved, it should be Shipped, if Days Since Last Delivery to the store is 3 days or more.? Otherwise, the trailer/truck stays on HoldHow can I adjust my function so that instead of giving an error it shows "HOLD"

X AutoSave On HW 2 2023 workbook (1) . Saved v Search File Home Insert Draw Page Layout Formulas Data Review View Automate Developer Help & Cut Arial 10 A 25 Wrap Text General Paste Copy BIU~ A E Merge & Center $ ~ % 68 98 Conditional Format Painter Formatting Undo Clipboard Font Alignment Number L4 iX fx =IFS($14="FALSE", "HOLD", AND($14="TRUE", $K4="TRUE"), "SHIP", AND( $14="TRUE", $K4="FALSE",$C4>="3"), "SHIP") A B C D E G K Transportation Status Report Fuel & Trailer Days Since Cubic Weight Current Current Maintenance Maintenance Capacity Ship or 2 Number Store # Last Delivery Capacity Capacity Cube Weight Fuel Required Read Achieved Hold 3 84053 500 5 1,240 6,000 1,200 5,800 Yes No TRUE TRUE SHIP 74048 850 3,840 4,500 1,400 2,800 Yes No TRUE FALSA #N/A 64022 650 1,760 3,000 1,200 2,200 Yes No TRUE FALSE #N/A 84153 800 4,240 6.000 4,000 5,000 No No FALSE TRUE #N/A 74148 825 3,840 4,500 1,800 4,200 Yes No TRUE TRUE SHIP 64122 875 1,760 3,000 0 0 Yes Yes FALSE FALSE #N/A 64222 775 1,760 3,000 1,650 2,200 Yes No TRUE TRUE SHIP 10 74248 715 3,840 4,500 2,000 4,250 No No FALSE TRUE #N/A 11 84253 835 4,240 6,000 0 0 No Yes FALSE FALSE #N/A - N AGI W CI A C - N W CI A N W - 12 84353 900 4,240 6,000 4,150 3,500 Yes No TRUE TRUE SHIP 13 64322 550 1,760 3,000 1,650 1.500 Yes No TRUE TRUE SHIP 14 74348 845 3,840 4,500 2,200 2,750 Yes No TRUE FALSE #N/A 15 64422 665 1,760 3,000 800 2,850 Yes No TRUE TRUE SHIP 16 84453 700 4,240 6,000 4,100 5,200 No No FALSE TRUE #N/A 17 74448 505 3,840 4.500 2.000 4,400 Yes No TRUE TRUE SHIP 18 74548 560 3,840 4,500 0 0 No Yes FALSE FALSE #N/A 19 64522 605 1,760 3,000 1,700 2,500 Yes TRUE TRUE SHIP 20 84553 705 4,240 6,000 4,200 5,200 Yes No TRUE TRUE SHIP 21 22