I am creating a Dim Weight calculator to determine the best way to ship. Is there a way to combine these four formulas into one?
I have multiple criteria to check and I may have multiple calculators to combine. This is one example.
IN CELL B18 =IF(AND(C16="Kilos",B16<68),"PARCEL", "")
IN CELL C18 =IF(AND(C16="Kilos",B16>68),"FREIGHT","")
IN CELL B19 =IF(AND(C16="POUNDS",B16>150),"FREIGHT","")
IN CELL C19 =IF(AND(C16="POUNDS",B16<150),"PARCEL","")
<tbody>
</tbody>
I have multiple criteria to check and I may have multiple calculators to combine. This is one example.
IN CELL B18 =IF(AND(C16="Kilos",B16<68),"PARCEL", "")
IN CELL C18 =IF(AND(C16="Kilos",B16>68),"FREIGHT","")
IN CELL B19 =IF(AND(C16="POUNDS",B16>150),"FREIGHT","")
IN CELL C19 =IF(AND(C16="POUNDS",B16<150),"PARCEL","")
<tbody> </tbody><colgroup><col><col><col></colgroup> |
<tbody>
</tbody>