combine several IF statements

I am trying to create a formula for an IF statement for my FEF eBay spreadsheet. Apparently, I cannot seem to combine several IF statements in sequence. I want to create a formula that will recognize the first shipment option that I chose and based on that option create a different option for the second slot. For example, If I decide to choose USPS Parcel Post for the First option, then the second shipment option will be USPS Priority and vice versa. Here is my attempt at this formula but it returns an error message.


=IF(inventory!AB2="USPSParcel",Text("USPSPriority'),IF(inventory!AB2="USPSMedia",Text("USPSPriority"),IF(inventory!AB2="USPSFirstClass",Text("USPSPriority") =IF(inventory!AB2="","","USPSParcel")

Not sure if this will help.

Please Login or Register  to view this content.

This seems to fit your formula, but not the description you give of your problem.