Formula

A

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
 
M

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
 
Top