if function

[peter]

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

 

[T. Valko]

Try this:

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

 

[Max]

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

 

[Roger Govier]

Hi Peter

No need to use IF's
Try
=A1*0.5-MAX(0,A1-1000)*0.1

 

[peter]

Thank you very much that did the trick...and thanx to everyone that
helped...a speedy response.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you very much that did the trick...and thanx to everyone that
helped...a speedy response.