Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating ranges
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating within Date Ranges | Excel Discussion (Misc queries) | |||
Calculating Date Ranges | Excel Worksheet Functions | |||
Calculating the number of values between specified ranges | Excel Discussion (Misc queries) | |||
Calculating rate based on age ranges | Excel Worksheet Functions | |||
Calculating with named ranges | Excel Discussion (Misc queries) |