greater than replace numbers

M

mja

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

Arvi Laanemets

Hi

Into empty column
=MIN(OldAmount,36000)


Arvi Laanemets


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using treater than and replacing numbers 1
Creating a Chart on form from selected data in query. 0
Replace in a group or selection or collection of word files 1
WORD VBA Search and switch to advanced ... 1
If greater than 5 4
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Adding cells until they are greater than a lookup cell and returning a value 1
Sliding Commission Formula 2

Top