 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008if 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 Try this: =IF(COUNT(A1),MIN(A1,1000)*0.5+MAX(A1-1000,0)*0.4,0)  SignatureBiff Microsoft Excel MVP > 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 Thank you very much that did the trick...and thanx to everyone that helped...a speedy response. :) > Try this: > [quoted text clipped - 5 lines] > > It all seemed so straught forward till i got to this. > > Thanx in advance You're welcome! SignatureBiff Microsoft Excel MVP > Thank you very much that did the trick...and thanx to everyone that > helped...a speedy response. :) [quoted text clipped - 8 lines] >> > It all seemed so straught forward till i got to this. >> > Thanx in advance 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 SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > 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 Hi Peter No need to use IF's Try =A1*0.5-MAX(0,A1-1000)*0.1 SignatureRegards Roger Govier > 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
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.