Help in formula creation

  • Thread starter Thread starter cesar_xl
  • Start date Start date
C

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.
 
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
 
Back
Top