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

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