greater than replace numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers.
I need to replace any amounts over $36,000.00 with the amount of $36,000.00.
 
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.
 
You must log in or register to reply here.

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
Total Gratuity Leave Please help 2
Combining sumIF statements with other functions? 2
MS word Find and Replace using Regex - Help required 0
Complex conditions using SUMIF 8
If/Or Clarified 2
count the number of rows with entries greater than zero 1
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT 9

Back
Top