Try this:

=IF(COUNT(A1),MIN(A1,1000)*0.5+MAX(A1-1000,0)*0.4,0)

--
Biff
Microsoft Excel MVP


"peter" wrote in message
...
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 straught forward till i got to this.
Thanx in advance