Formula

[agungf84]

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

[Mallycat]

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