Forum Discussion

reyg6's avatar
reyg6
Copper Contributor
Oct 13, 2022

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!

  • reyg6 

    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.

Resources