I am trying desperately to create a formula in my spreadsheet that will
automatically calculate shipping cost for me based on weight. Here is my
scenario:
I have one column that calculates the weight per item.
I have the total weight entered into one cell (H42) on my sheet.
Based on the weight in cell H42, I need to determine three different factors:
a) If weight is less than 250 pounds, I need cell H42 multiplied by $1
b) If weight is BETWEEN 250 and 999 pounds, I need cell H42 multiplied by
total invoice order in cell AV42 (don't worry ... my columns are all 1 inch
wide and I merged some together)
c) If weight is greater than 1000 lbs, the shipping is a set price.

Any help will be greatly appreciated! I cannot figure this formula out by
using the IF function. I don't know how to set it the values 250<999. Excel
doesn't recognize what I am telling it to do! Please help!

Thanks!