Donna,

A formula cannot directly change the value in any cell other than the cell
the formula is in so you have 2 choices.

lets assume thes evalues are in a1 down, In B1 enter
=IF(MAX($A$1:$A$100)=A1,200,"")

Or you need a macro.

Mike



"Donna" wrote:

Thanks. Now what is the formula for finding the largest value and then
inserting $200 in the next column, same row?

"Mike H" wrote:

Maybe

=Max(A1:a100)

Mike

"Donna" wrote:

How do I find the largest value in a range?