Hi,
Look at this image (attachment demo file)
13.png
I want to add 2.5 to all values in column C1 if the value is lower than 7.4, but at the same time, the result must not exceed 7.5 as it is the upper limit
In more detail, if I add 2.5 to 6.5, it will be 9.5 which exceeds my upper limit (7.5), so 6.5 must be converted to 7.5
also when I add 2.5 to 7.4, it must be 7.5.
So how to do that with my thanks