Change values automatically

**Kribulin** · 06-03-2008, 10:05 AM

Hello everyone!

I have 2 huge columns with data. The value of every single cell in column 2 is the final result, unless

1) this value is larger than 1800. Then the value has to be changed to 1800 (which is the final result of this cell)

or

2) the corresponding value in column 1 is smaller than 5. Then the value of column 2 has to be changed to 0. (which is the final result of this cell)

How do I write this in column 3?

Thanks in advance!

**ChemistB** · 06-03-2008, 11:08 AM

Assuming we're starting in B2

=IF(A2<5,0,MIN(1800, Formula))

where formula is whatever formula you put in B2 to generate the result initially. If that value is >1800, it'll choose 1800. Does that work for you?

NOTE: This formula can be put into column 2. You don't need a column 3. If you want to have column 2 as is, then change the formula to