Thread
:
greater than replace numbers
View Single Post
#
2
Arvi Laanemets
Posts: n/a
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.
Reply With Quote