If Statements and Arrays
 

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

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

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