I need to write a formula in a single cell that says,
If c4 is greater than or equal to k4 and less than or equal to m4, then c4*j4.
But, if c4 is greater than or equal to k5 and less than or equal to m5, then c4*j5
But, if c4 is greater than or equal to k6 and less than or equal to m6, then c4*j6
But, if c4 is greater than or equal to k7, then c4*j7.
Is there any way for this to be done? I put an example below of what the spreadsheet looks like. KM is a range that may change in the future, thus why I cannot just type the numbers in.
(C) (E) (J) (K) (M)
# of Orders $ Amount # of Orders
10 $9.00 1 - 250
20 $8.50 251 - 1000
30 $7.75 1001 - 3000
40 $7.00 3001 +
Bookmarks