Ολοκληρωμένο

Excel formula needed to determine fee based on several columns of data

I am trying to calculate shipping fees of products based on weight and dimensions. In addition to the basic fees based on weight, there are fees for oversized or overweight items.

The rules for that are;

Packages will also incur a Carrier imposed, “Additional Handling” charge ($10.50), which shall be added to the Program’s rate calculation at time of shipment for any package that exceeds the following limitations:

Any item with one dimension measuring over 60 inches, but equal to or less than 108 inches along its longest side.

Any item dimensions measuring greater than 30 inches along its second‐longest side

Additionally, FedEx SmartPost and UPS Mail Innovations packages will also incur a Carrier imposed, USPS “non‐machineable” charge ($2.25), which shall be added to the Program’s rate calculation at time of shipment for any package that exceeds the following limitations:

Any item with one dimension measuring over 34 inches.

Any item with two dimensions each measuring more than 17 inches.

Any item weighing over 35 lbs.

Thanks to some help here yesterday, I was able to get a formula for the final three items. I still need help with the first two.

What I need from you is either a) [preferable] a single formula that takes all 5 into account or b) a formula that solves the first two and then also cancels out the reults of the last three. I do not need to charge 10.50 AND 2.25.

A sample doc is attached.

Ικανότητες: Επεξεργασία Δεδομένων, Excel

Περισσότερα: excel compare columns data, derivation formula based series data, excel align columns data, pdf ocr excel columns data, pair columns data excel, data needed excel spreadsheet, vba formula rank excel columns, link multiple columns data data list excel, excel vba compare columns data report, sum data based columns excel, excel vba macro copy columns data, transform cvs data formula cells excel, summing excel based multiple data, excel manipulate columns data source, generate data based columns excel visual basic script

Σχετικά με τον Εργοδότη:
( 12 αξιολογήσεις ) Chicago, United States

Ταυτότητα Εργασίας: #13389120

Ανατέθηκε στον:

Psmith1979

Hello, I have written a formula that fulfills the criteria in the brief and tested it on your spreadsheet successfully. I have then combined this with the existing formula for the $2.25 fee so that only one fee is ap Περισσότερα

$10 USD σε 1 μέρα
(2 Αξιολογήσεις)
1.3

29 freelancers κάνουν προσφορές κατά μέσο όρο $30 για αυτή τη δουλειά

sandroshubladze

Hi I am Excel Expert and VBA Programmer I can set spreadsheet as you need with proper formulas PM if interested Thanks & Regards

$35 USD σε 1 μέρα
(172 Αξιολογήσεις)
7.2
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD σε 1 μέρα
(271 Αξιολογήσεις)
7.1
$50 USD σε 1 μέρα
(184 Αξιολογήσεις)
6.7
$65 USD σε 3 μέρες
(71 Αξιολογήσεις)
6.6
ksriniravi

Greetings! I have reviewed your requirement and understand the same completely. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation simila Περισσότερα

$20 USD σε 0 μέρες
(140 Αξιολογήσεις)
6.5
dpune

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my em Περισσότερα

$30 USD σε 1 μέρα
(124 Αξιολογήσεις)
6.3
ZedExcel

Hi. I have done one formula that takes into account all 5 conditions. Just clarify one thing for me. On the first condition, can the >60 inch condition be on the longest side or should this be on the other two sides?

$10 USD σε 0 μέρες
(32 Αξιολογήσεις)
5.8
$15 USD σε 1 μέρα
(93 Αξιολογήσεις)
5.7
sajibdigital

Hi I would like to work on your project. I hope you will be fully satisfied after completing this project with me. You may view my profile to know about my expertise. I have 38 review with 5 Star rating. I pray and Περισσότερα

$20 USD σε 1 μέρα
(59 Αξιολογήσεις)
5.6
PerfectChoic3

Hello Sir, I carefully read through your project description and understood about your requirements .I can perfectly complete your job without any [login to view URL]"s start [login to view URL]

$25 USD σε 1 μέρα
(61 Αξιολογήσεις)
5.8
beltran0404

Hello, It will be my pleasure to help you with this project. I have experience with calculation in excel. Please contact me by chat and then we could discuss better your project. Looking forward to hear from you Περισσότερα

$25 USD σε 1 μέρα
(82 Αξιολογήσεις)
5.1
sourabhg98

Hello This is Sourabh Gupta from New Delhi. I am advanced Excel VBA programmer and specialize in creating customized workbooks for businesses and people to meet all their needs efficiently and effectively. Cur Περισσότερα

$25 USD σε 1 μέρα
(50 Αξιολογήσεις)
4.7
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the Περισσότερα

$30 USD σε 1 μέρα
(35 Αξιολογήσεις)
5.0
EngrShahidul

I am much experience in Excel and SPSS data analysis, power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. I have Περισσότερα

$25 USD σε 1 μέρα
(20 Αξιολογήσεις)
4.6
telfordm

Hi, I am a native English speaking finance professional with over 15 years experience using Excel. I can help with your project. Your instructions and explanations below are very clear. My only question is - are the Περισσότερα

$36 USD σε 2 μέρες
(12 Αξιολογήσεις)
4.3
ChiragLathiya

Message me before you gonna award this project to me Message me before you gonna award this project to me Message me before you gonna award this project to me Message me before you gonna award this project to me Me Περισσότερα

$20 USD σε 1 μέρα
(11 Αξιολογήσεις)
3.9
humayoonsheikh4u

A proposal has not yet been provided

$72 USD σε 1 μέρα
(10 Αξιολογήσεις)
4.1
kushalparwani27

I am a post graduate in Finance with more than one year of experience as a Financial Analyst. My work included: • Writing annual credit review reports for corporate and banks with a focus on competitive industry analy Περισσότερα

$70 USD σε 1 μέρα
(20 Αξιολογήσεις)
4.0
Goalaholic

We are team of Excel Experts with 5 years of similar experience. We have written several complicated formulas to meet conditions and develop models. Looking for your response.

$30 USD σε 1 μέρα
(18 Αξιολογήσεις)
3.8
$30 USD σε 1 μέρα
(2 Αξιολογήσεις)
3.7