Forum Discussion
reyg6
Oct 13, 2022Copper Contributor
Changing a value if it’s under some number to a certain number, and keeps the value if it’s above.
Hi. I am making a table about school grades, and I want to change every grades under 70 to 70, but keeps the same number if it is above 70. (e.g.: if the value is 50, then the result is 70. But if ...
HansVogelaar
Oct 13, 2022MVP
Let's say you have grades in G2 and below.
In (for example) H2, enter the formula =MAX(G2, 70)
The formula can be filled or copied down.