ExcelBanter - greater than replace numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - greater than replace numbers (https://www.excelbanter.com/excel-worksheet-functions/18939-greater-than-replace-numbers.html)

mja

greater than replace numbers

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

Arvi Laanemets

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.

All times are GMT +1. The time now is 05:36 AM.