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