Need function to calculate mathmatic formula base on two critera

  • Thread starter Thread starter SPenney
  • Start date Start date
S

SPenney

I'm trying to design a rate-calculator for shipping purposes.

The criteria I need to consider is if it is "LTL" or "TL" in one cell.
In the other cell, I have the number of stops the truck makes (1-3.)

I am using a vlookup to get the rate for the destination and referenc
that within the cell (A10). Milage is hand-keyed (A11)

The end result needs to be if A12=(LTL or TL) and A13=(1 or 2 or 3)
then I need to multiply the rate times the miles, factor a percent of
if LTL, and add in the charge for the number of stops.

So far I have arrived a
IF($A$12="LTL",(0.89*($A$10*$A$11)),IF($A$12="TL",($A$10*$A$11)))

This doesn't get the stop charges added in. I'd like to accomplis
this in one formula if possible, but can't figure away to get there.

Thanks looking and any assistance you might be able to provide.

Staci
 
Hi
could you provide us with the factors for each possible combination of
A12 and A13. and your expected result for this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need function to calculate mathmatic formula base on two critera 2
sumproduct? 3
Help with IF function 4
Nested If 3
How do I create the formula for this calculation? 1
Advanced Filter Critera using formula not working 5
Need help with this "StringConcat" formula 1
help with datedif function please 4

Back
Top