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

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