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.

Help in formula creation
 

http://www.google.com/search?sourcei...l%3acommission

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cesar_xl" wrote in message
...
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.

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.