I have a time series of a lot of numbers, which range from zero to any number. I want to treat all numbers above one as if they are one, but leave the numbers below one unchanged.

For example 2.3456 would become 1.0, but 0.76345 would stay as 0.76345.

What is the simplest way of doing this please? Is there a function that can do it, rather than having to use conditional logic expressions?

I also want to do another separate series of calculations where all numbers below one become one, but numbers above one are unchanged.