Combine Multiple Formulas for Dim Weight

[VJVJVJ]

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","")

Dimensional Weight Calculator PALLET/BOX #1 Select from List Unit of Measurements CM/KG Actual Weight 500 =IF($B$5="CM/KG","Kilos",IF($B$5="CBM","KILOS","Pounds")) Fill in metrics Length 75 =IF($B$5="CM/KG","CM",IF($B$5="CBM","CM","Inches")) Width 100 =IF($B$5="CM/KG","CM",IF($B$5="CBM","CM","Inches")) Height 42 =IF($B$5="CM/KG","CM",IF($B$5="CBM","CM","Inches")) CBM Manual 1.5 DIM Weight =IF($C$7="pounds",($B$9*$B$10*$B$11)/139*0.453592,IF($C$7="cbm",$B$13/5000*1000000,$W$49)) Kilos Weight to Use =IF(AND($C$7="Pounds",$B$7*0.453592,$B$7)>B15,B15) Kilos If Weight <150lbs/68kilo =IF(AND(C16="Kilos",B16<68),"PARCEL", "") =IF(AND(C16="POUNDS",B16<150),"PARCEL","") >150lbs/68kilos =IF(AND(C16="Kilos",B16>68),"FREIGHT","") =IF(AND(C16="POUNDS",B16>150),"FREIGHT","") <tbody> </tbody><colgroup><col><col><col></colgroup>

<tbody>
</tbody>

 

[bbott]

=IF(OR(AND(C16="Kilos",B16<68),AND(C16="POUNDS",B16<150)),"PARCEL", IF(OR(AND(C16="Kilos",B16>68),AND(C16="POUNDS",B16>150)),"FREIGHT",""))

 

[VJVJVJ]

=IF(OR(AND(C16="Kilos",B16<68),AND(C16="POUNDS",B16<150)),"PARCEL", IF(OR(AND(C16="Kilos",B16>68),AND(C16="POUNDS",B16>150)),"FREIGHT",""))

Thank you it worked- Too many If, Ands', and OR's'. Could not make the combination work on my own.Thanks

 

[bbott]

You're welcome.