 |
 | 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 / Worksheet Functions / June 2006minimum
hi how can i do the following equation? 40$ if the sum is less than 1000$ 75$ if the sum is less than 1001$ t0 3000$ 100$ if the sum is less than 3001$ 3001$ and up no minimum all should go in one cell thanks Rid I'd probably do it with a lookup myself, but =if(CellTested<1000,40,if(CellTested<3000,75,if(CellTested<3001,100,"no minimum"))) will do it for you - I've written it with the bounds you specified > hi > [quoted text clipped - 15 lines] > ridash's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35617 > View this thread: http://www.excelforum.com/showthread.php?threadid=554015 It can be done with anested if statement or with a vlookup. however you example ranges overlap and so an answer can not be given your thri range <3000 is also covering the same date as your first 2 ranges If you resate you will get an answer Regards Da ~Actually, the ranges don't overlap, but the last range is only a dollar in size - hence my comment on my reply that I'd done it with the ranges as specified!! > It can be done with anested if statement or with a vlookup. however your > example ranges overlap and so an answer can not be given your thrid [quoted text clipped - 11 lines] > Dav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27107 > View this thread: http://www.excelforum.com/showthread.php?threadid=554015 If you read my post I made no mention of the 4th range, however as the third range does not have a lower bound, they do overlap > 40$ if the sum is less than 1000$ > 75$ if the sum is less than 1001$ t0 3000$ > 100$ if the sum is less than 3001$ > 3001$ and up no minimum in you logic 1000 is included in the less than 3000 statement, which can not be true! the 2nd statment makes no sense <1001 to 3000 yours would include 1000 as written it is unclear also if < or <= should be used I would guess the later to exclude gaps Regards Dav Dav  SignatureDav |
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
|
©2009 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.