If Calculation

[Guest]

Calculate the first 600 units @ 5c per unit, above 600 units calculate @ 5.8c
per unit

 

[Guest]

if(a1<=600,A1*5,600*5+(a1-600)*5.8) cents

HTH

 

[joeu2004]

Calculate the first 600 units @ 5c per unit, above 600 units
calculate @ 5.8c per unit

Can you say "please"? Oh well ....

If A1 contains the number of units:

=5*A1 + 0.8*max(0,A1-600)

Note: That formula is in units of "c". If "c" is cents and you
want the formula to be in units of dollars, use 0.05 and 0.008
instead of 5 and 0.8 respectively.

 

[Paul B]

skateblade, Elkar gave you an answer in your other question, just change the
amounts you want to use this time,

=MIN(A1,600)*0.05+MAX(A1-600,0)*0.058

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

hi,
assuming that your quantity is in A1, try this...
=IF(A1>600,(600*0.05)+((A1-600)*0.058),A1*0.05)
regards
FSt1