Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help - Perform a calculation only if the result falls between 2 values
I have 4 columns (Weight, Rate, Min Charge, Max Charge). I am looking
for a formula that will return the correct charge whether it be the Weight*Rate calculation, Min Charge or the Max Charge. If the Weight*Rate is less than the Min Charge then return the Min Charge. If the Weight*Rate is greater than the Max charge then return the Max Charge. If the Weight*Rate is between the Min Charge and the Max Charge return the Weight*Rate calculation. Sample Data: Weight Rate Min Max 1280 $4.70 $89.00 $225.00 6598 $4.50 $124.00 $270.00 (1280 is in cell A2) Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create formula-if value A falls between values B and C in time for | Excel Discussion (Misc queries) | |||
How do I perform calculation on Filtered data | Excel Discussion (Misc queries) | |||
formula result #value! needs to equal zero for average calculation | Excel Worksheet Functions | |||
comparing two columns & then perform a calculation | Excel Worksheet Functions | |||
Perform functions on the result of adding two columns | Excel Worksheet Functions |