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

 

[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.