Here is a quick sample:
The following is entered in an empty Cell or Column - I used Column B
for the following formula - the value you want to evaluate is in Cell
A2.
=IF(A20,A2,0)
Read as: if A2 is greater than 0, then I want the value of A2 in cell
B2 - If the value is 0 or less than 0, (i.e. -1) then the value is 0.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=523286