if function
 

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

if function
 

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

if function
 

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

if function
 

Hi Peter

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

--
Regards
Roger Govier

"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

if function
 

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

"T. Valko" wrote:

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

if function
 

You're welcome!

--
Biff
Microsoft Excel MVP


"peter" wrote in message
...
Thank you very much that did the trick...and thanx to everyone that
helped...a speedy response. :)

"T. Valko" wrote:

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