If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help in formula creation
Hi all.
I need help creating a formula that will let me get a total by calculating increasing values according to the # of items entered. Example. Buy between 1&6 at $6.50 + $15.0 (shipping), 7 & 14 at $6.00 + $20, 15 & 29 at $5.50 + $25, 30 & 49 at $4.50 + $30.0 Can this be done?.. Thanks in advance. |
#2
|
|||
|
|||
Help in formula creation
http://www.google.com/search?sourcei...l%3acommission
-- Don Guillett Microsoft MVP Excel SalesAid Software "cesar_xl" wrote in message news Hi all. I need help creating a formula that will let me get a total by calculating increasing values according to the # of items entered. Example. Buy between 1&6 at $6.50 + $15.0 (shipping), 7 & 14 at $6.00 + $20, 15 & 29 at $5.50 + $25, 30 & 49 at $4.50 + $30.0 Can this be done?.. Thanks in advance. |
#3
|
|||
|
|||
Help in formula creation
With items in cell A1; try the below formula
=IF(VALUE(A1),A1*LOOKUP(A1,{1,7,15,30},{6.5,6,5.5, 4.5})+ LOOKUP(A1,{1,7,15,30},{15,20,25,30}),"") If this post helps click Yes --------------- Jacob Skaria "cesar_xl" wrote: Hi all. I need help creating a formula that will let me get a total by calculating increasing values according to the # of items entered. Example. Buy between 1&6 at $6.50 + $15.0 (shipping), 7 & 14 at $6.00 + $20, 15 & 29 at $5.50 + $25, 30 & 49 at $4.50 + $30.0 Can this be done?.. Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|