Help in formula creation

[cesar_xl]

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.

 

[Don Guillett]

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GFRD_en___US219&q=excel:commission

 

[Jacob Skaria]

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