View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Into empty column
=MIN(OldAmount,36000)


Arvi Laanemets


"mja" wrote in message
...
I have a column of numbers.
I need to replace any amounts over $36,000.00 with the amount of

$36,000.00.