so a range of twenty rows x2 columns need to "report" back to one cell to
give a multiple of 150 or 0? or is each row treated seperately like your
example and then all added up
--
paul
remove nospam for email addy!



"prbucci" wrote:


I have a colum of 20 cells and every one of them need to be checked to
see if they meet the required amount and if not they need to be
reported to one cell and tabulated at 150 each. the $ does nt matter


--
prbucci
------------------------------------------------------------------------
prbucci's Profile: http://www.excelforum.com/member.php...o&userid=30428
View this thread: http://www.excelforum.com/showthread...hreadid=501425