Formula
 

Hi all,

I am new to this website and am wondering if anybody can help me. I
want to form a formula that if number 6000,4000,2000, or 0 appear, that
it will produce 20000.

Thanks!

Cheers,
Agung


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

Formula
 

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