If Statements and Arrays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I'm trying to do is something like:

=J6*if(O6<{A3:A39},{B3:B39},.14)

What it pretty much is is that if O6 is less than some percentage {A3:A39},
then multiple the corresponding dollar amount {B3:B39} by J6, and if it is
greater than the % in B39, then multiple J6 by .14 .... so I want 27.15% * .09

If anyone knows what the **** I'm talking about, you get a cookie!! And if
you can answer my questions, you get another cookie!! Any help would be
appreciated!!
 
Ok I sincerely apologize for the confusion. Let me see if I can just paste
everything and go from there.

A B C O
P
Construction Incentives &Difference kWh Rebate $
kWH
% Savings $ / kWh $ / Therm 27.19% =array
0 0 0
1 0 0 So I want the formula to look at 27.19 (O6) and go through
2 0 0 % Savings (A) and go to 27, then use $ / kWh (B)
3 0 0 and multiply that by another cell (J6). Therefore,
4 0 0 =0.094*374,969. Disregard the $ / Therm!!
5 0 0
6 0 0
7 0 0
8 0 0
9 0 0
10 0 0
11 0 0
12 0 0
13 0 0
14 0 0
15 0.050 0.500
16 0.053 0.530
17 0.055 0.550
18 0.058 0.580
19 0.062 0.620
20 0.065 0.650
21 0.069 0.690
22 0.072 0.720
23 0.076 0.760
24 0.081 0.810
25 0.085 0.850
26 0.090 0.900
27 0.094 0.940
28 0.099 0.990
29 0.105 1.050
30 0.110 1.100
31 0.116 1.160
32 0.121 1.210
33 0.127 1.270
34 0.134 1.340
35 0.140 1.400
 
Back
Top