greddy2die
New Member
- Joined
- Oct 18, 2019
- Messages
- 8
Hi again,
I really appreciate everyone's help in the past & i'm back for more! haha, sorrrry.
Is there a relatively easy formula or some kind of calculation that, lets say for instance, if I put in B1 "7" & B2 "11" it would know to pull the price ($3.40) where those 2 numbers intersect? I'm trying to put together this calculator for an office of mine to help speed up their productivity and this rate sheet I have has me stumped since i'm very much an excel novice.
The rate needed will vary greatly depending on which 2 "zones" someone chooses. I dont want to put an IF formula for every single box below.
I really appreciate everyone's help in the past & i'm back for more! haha, sorrrry.
Is there a relatively easy formula or some kind of calculation that, lets say for instance, if I put in B1 "7" & B2 "11" it would know to pull the price ($3.40) where those 2 numbers intersect? I'm trying to put together this calculator for an office of mine to help speed up their productivity and this rate sheet I have has me stumped since i'm very much an excel novice.
The rate needed will vary greatly depending on which 2 "zones" someone chooses. I dont want to put an IF formula for every single box below.
ZONE 1 | 7 | |||||||||||||||||||||||||||
ZONE 2 | 11 | ZONE 2 | ||||||||||||||||||||||||||
ZONE | 1 | 2 | 2A | 3 | 4 | 5 | 6 | 7 | 8 | SA | 9 | 10 | 11 | 12 | 12A | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | Stream | ||||
1 | $2.50 | $2.71 | $3.79 | $3.35 | $3.51 | $2.07 | $3.40 | $2.60 | $2.02 | $4.72 | $1.92 | $2.93 | $1.97 | $3.19 | $3.35 | $3.35 | $3.56 | $3.72 | $3.40 | $1.92 | $2.02 | $3.56 | $1.92 | $1.92 | ||||
2 | $2.71 | $2.60 | $3.64 | $3.35 | $3.51 | $2.45 | $5.31 | $4.62 | $2.28 | $4.78 | $2.28 | $3.19 | $2.66 | $3.72 | $3.72 | $3.35 | $3.56 | $3.72 | $3.40 | $2.14 | $2.02 | $3.56 | $1.92 | $2.14 | ||||
2A | $3.79 | $3.64 | $3.64 | $3.70 | $4.20 | $3.43 | $5.60 | $6.00 | $3.19 | $6.00 | $3.19 | $3.55 | $3.72 | $5.20 | $5.20 | $4.69 | $4.98 | $5.20 | $4.26 | $2.99 | $3.10 | $4.98 | $2.90 | $2.99 | ||||
3 | $3.35 | $3.35 | $3.70 | $2.93 | $3.35 | $3.29 | $5.31 | $3.51 | $2.66 | $4.89 | $2.66 | $3.35 | $3.03 | $3.72 | $3.72 | $3.72 | $3.77 | $3.72 | $3.77 | $2.76 | $2.87 | $3.72 | $2.76 | $2.76 | ||||
4 | $4.20 | $4.20 | $4.20 | $4.90 | $4.21 | $4.21 | $5.16 | $5.50 | $3.90 | $5.50 | $4.05 | $4.75 | $4.69 | $4.78 | $6.15 | $4.95 | $5.16 | $5.75 | $4.42 | $3.99 | $4.09 | $5.22 | $3.90 | $3.99 | ||||
5 | $2.07 | $2.45 | $3.43 | $3.29 | $3.51 | $2.50 | $4.36 | $2.50 | $2.50 | $4.94 | $2.66 | $4.46 | $2.66 | $3.72 | $3.99 | $3.51 | $3.61 | $3.72 | $2.82 | $1.65 | $1.87 | $3.56 | $1.87 | $1.65 | ||||
6 | $3.40 | $5.31 | $5.60 | $5.31 | $4.46 | $4.36 | $4.41 | $3.61 | $2.60 | $4.25 | $3.46 | $4.14 | $4.78 | $4.46 | $4.46 | $4.52 | $4.78 | $4.78 | $4.36 | $4.46 | $4.52 | $5.58 | $4.19 | $4.09 | ||||
7 | $2.60 | $4.62 | $6.00 | $3.51 | $4.04 | $2.50 | $3.61 | $4.46 | $2.50 | $4.30 | $2.66 | $3.40 | $3.40 | $3.72 | $3.77 | $3.77 | $3.88 | $4.04 | $3.77 | $4.19 | $4.62 | $4.36 | $2.34 | $3.61 | ||||
ZONE 1 | 8 | $2.02 | $2.28 | $3.19 | $2.66 | $3.13 | $2.50 | $3.13 | $2.50 | $1.81 | $4.72 | $1.81 | $3.40 | $2.40 | $3.72 | $3.72 | $3.72 | $3.03 | $3.61 | $2.93 | $1.70 | $1.87 | $3.93 | $1.65 | $1.70 | 8 | ||
8A | $4.72 | $4.78 | $6.00 | $4.89 | $4.94 | $4.94 | $3.72 | $4.30 | $4.72 | $4.72 | $4.62 | $4.67 | $4.72 | $4.78 | $4.78 | $4.67 | $4.67 | $4.78 | $4.89 | $4.62 | $4.67 | $5.10 | $4.62 | $4.62 | ||||
9 | $1.92 | $2.28 | $3.19 | $2.66 | $3.35 | $2.66 | $3.46 | $2.66 | $1.81 | $4.62 | $2.50 | $2.93 | $2.60 | $3.99 | $4.04 | $3.35 | $3.51 | $3.72 | $3.61 | $1.87 | $1.97 | $2.82 | $1.92 | $1.87 | ||||
10 | $2.93 | $3.13 | $3.55 | $3.35 | $4.09 | $4.46 | $4.14 | $3.40 | $3.40 | $4.67 | $2.93 | $3.72 | $3.72 | $3.72 | $3.93 | $3.83 | $4.06 | $3.72 | $3.77 | $2.93 | $3.08 | $3.35 | $2.93 | $2.93 | ||||
11 | $1.97 | $2.66 | $3.72 | $3.03 | $3.99 | $2.66 | $4.78 | $3.40 | $2.40 | $4.72 | $2.60 | $3.72 | $2.28 | $3.51 | $3.56 | $3.08 | $4.25 | $3.56 | $3.61 | $1.87 | $2.87 | $2.87 | $2.02 | $1.87 | ||||
12 | $3.13 | $3.72 | $5.20 | $3.72 | $4.04 | $3.72 | $4.46 | $3.72 | $3.72 | $4.78 | $3.99 | $3.72 | $3.51 | $3.56 | $3.72 | $3.72 | $3.77 | $4.46 | $4.19 | $3.40 | $3.77 | $3.77 | $3.35 | $3.40 | ||||
12A | $3.35 | $3.72 | $5.20 | $3.72 | $5.47 | $3.99 | $4.46 | $3.72 | $3.72 | $4.78 | $4.04 | $3.99 | $3.56 | $3.72 | $3.93 | $3.88 | $3.99 | $4.46 | $4.46 | $4.41 | $4.52 | $4.94 | $4.04 | $4.41 | ||||
13 | $3.35 | $3.35 | $4.69 | $3.72 | $4.25 | $3.51 | $4.52 | $3.72 | $3.72 | $4.67 | $3.35 | $3.83 | $3.08 | $3.72 | $3.88 | $3.72 | $3.72 | $4.46 | $3.56 | $3.03 | $3.08 | $3.08 | $2.93 | $3.08 | ||||
14 | $3.56 | $3.56 | $4.98 | $3.72 | $4.46 | $3.61 | $4.78 | $3.72 | $3.72 | $4.72 | $3.51 | $4.06 | $3.13 | $3.77 | $3.99 | $3.72 | $3.72 | $4.46 | $3.61 | $3.44 | $3.29 | $2.93 | $3.72 | $2.93 | ||||
15 | $3.72 | $3.72 | $5.20 | $3.72 | $5.05 | $3.72 | $4.78 | $4.04 | $3.83 | $4.78 | $3.72 | $3.72 | $3.56 | $4.46 | $4.46 | $4.46 | $4.46 | $4.04 | $3.61 | $4.57 | $4.04 | $4.36 | $4.04 | $3.88 | ||||
16 | $3.40 | $3.40 | $4.26 | $3.72 | $3.72 | $2.82 | $4.36 | $3.72 | $3.88 | $4.89 | $3.61 | $3.77 | $3.61 | $4.19 | $4.41 | $3.56 | $3.61 | $3.61 | $2.82 | $4.52 | $4.52 | $3.29 | $3.29 | $2.76 | ||||
17 | $1.92 | $2.14 | $2.99 | $2.76 | $3.99 | $1.65 | $4.46 | $4.25 | $1.70 | $4.62 | $1.87 | $2.93 | $1.87 | $3.40 | $4.41 | $3.08 | $3.44 | $4.57 | $4.41 | $1.60 | $1.87 | $3.72 | $1.92 | o.oc | ||||
18 | $2.02 | $2.02 | $3.10 | $2.87 | $3.51 | $1.87 | $4.52 | $4.62 | $1.87 | $4.67 | $1.97 | $3.08 | $1.97 | $3.56 | $4.52 | $3.08 | $3.29 | $4.04 | $4.52 | $1.87 | $1.92 | $3.88 | $2.02 | 0.00 · | ||||
19 | $3.56 | $3.56 | $4.98 | $3.72 | $4.52 | $3.56 | $5.58 | $4.36 | $3.93 | $5.10 | $2.82 | $3.35 | $2.87 | $3.77 | $4.94 | $3.08 | $2.93 | $4.36 | $3.29 | $3.72 | $3.88 | $1.92 | $3.56 | $0.00 | ||||
20 | $1.92 | $1.92 | $2.90 | $2.76 | $3.03 | $1.87 | $4.19 | $2.28 | $1.65 | $4.62 | $1.92 | $2.93 | $2.02 | $3.35 | $4.04 | $2.93 | $3.72 | $4.04 | $3.29 | $1.92 | $2.02 | $3.56 | $1.87 | $0.00 | ||||