Greater than and less than combined in one formula

[JeroenCarlos]

Hi all,

I need to create a formula where the cell value of the formula needs to be between two numbers, 1 and 6. Also, everything above 6 should become 6, and everything below 1 should become 1. Naturally, everything in between shouldn't be changed.

Hope you can help!

Thanks in advance,

Jeroen

[rorya]

You can use MEDIAN:

=MEDIAN(A1,1,6)

for example.

[JeroenCarlos]

Well, that was easy.
Thank you!