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