One way ..
Assuming quantities in A1 down
Place in B1:
=IF(A1="","",IF(A1<=1000,A1*0.5,(A1-1000)*0.4+500))
Copy B1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"peter" wrote:
Hi doing my cert 2 and i am stuck on 1 formula
i need to work out the total cost of something where the first 1000 are
$0.50 and anything over 1000 is $0.40 using if function.
It all seemed so straight forward till i got to this.
Thanx in advance