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 the value is 89, then the value will still at 89).
What kind of formula should I use?
Thanks in advance!
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.