If Calculation

S

skateblade

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

joeu2004

skateblade said:
Calculate the first 600 units @ 5c per unit, above 600 units
calculate @ 5.8c per unit
Click to expand...

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.
 
P

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
 
F

FSt1

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
 
Top