Not sure if this is the most elegant solution, but it will work

Assuming your data is in cell A1

=IF(OR(A1=2000,A1=4000,A1=6000,A1=0),2000,A1)

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552999