Hi I was wondering if the replace function is good for what I am trying to do.
I have a list of numbers and I want to make sure they dont go beyond a certain max value. so if the max value is say 10 a number in the list with a value of 11 would come back as 10 yet 9 for example still be 9. I think the Replace function is supposed to do that however I cant get the syntax. Replace(x, x>10, 10). Thanks a lot. Stan
