C
Connie
Hello,
I require a formula that brings a result based on 2 different calculations.
First I need to calculate a dollar amount for weights between the ranges of 0
to 500 lbs, 501 to 1000 lbs, 1001 to 2000 lbs and so on up the scale. I will
have a column for each range. The second part of the calcuation is that the
end result can't be less than $18 or more than $200.
Here's a table that might help:
Weight 500 1000 2000
470 $19.10
750 $35.00
1500 $50.00
220 $18.00
Any help will be much appreciated.
Thanks.
I require a formula that brings a result based on 2 different calculations.
First I need to calculate a dollar amount for weights between the ranges of 0
to 500 lbs, 501 to 1000 lbs, 1001 to 2000 lbs and so on up the scale. I will
have a column for each range. The second part of the calcuation is that the
end result can't be less than $18 or more than $200.
Here's a table that might help:
Weight 500 1000 2000
470 $19.10
750 $35.00
1500 $50.00
220 $18.00
Any help will be much appreciated.
Thanks.