Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum
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 Rida -- ridash ------------------------------------------------------------------------ ridash's Profile: http://www.excelforum.com/member.php...o&userid=35617 View this thread: http://www.excelforum.com/showthread...hreadid=554015 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum
I'd probably do it with a lookup myself, but
=if(CellTested<1000,40,if(CellTested<3000,75,if(Ce llTested<3001,100,"no minimum"))) will do it for you - I've written it with the bounds you specified ridash wrote: 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 Rida -- ridash ------------------------------------------------------------------------ ridash's Profile: http://www.excelforum.com/member.php...o&userid=35617 View this thread: http://www.excelforum.com/showthread...hreadid=554015 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum
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 range <3000 is also covering the same date as your first 2 ranges If you resate you will get an answer Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=554015 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum
~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!! Dav wrote: 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 range <3000 is also covering the same date as your first 2 ranges If you resate you will get an answer Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=554015 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minimum
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 -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=554015 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Second highest minimum in a group | Excel Worksheet Functions | |||
minimum from various columns without zeroes | Excel Worksheet Functions | |||
second minimum value | Excel Discussion (Misc queries) | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Sum minimum values in a pivot table | Excel Worksheet Functions |