Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! |
#2
|
|||
|
|||
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!! |
#3
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL ARRAYS & IF STATEMENTS | Excel Worksheet Functions | |||
Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions |