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