If Statements and Arrays
 

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
35 0.140 1.400


"Peo Sjoblom" wrote:

Assume O6 is 6%, J6 is 2, let's say we use A1:A5 and B1 B5 and it looks like

what would you like the result to be then?

10% 2
5% 3
10% 2
5% 3
10% 2



Regards,

Peo Sjoblom

"Currie" wrote:

Not exactly. There is no sum. The only mathematical operation is the
product of the if statement multipled by J6.

If you need a better explanation, I think I'm SOL. The explanation I gave
is pretty much the only way I can describe it. If you absolutely do need a
better explanation, I can do my best.

"Peo Sjoblom" wrote:

Do you want to add O6<A3:A39*J6 and O6=A3:A39*0.14?
If so

=(SUMIF(A3:A39,"<"&O6,B3:B39)*J6)+(SUMIF(A3:A39," ="&O6,B3:B39)*0.14)


Regards,

Peo Sjoblom

"Currie" wrote:

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!!