Excel if statement

[JohnboyKGS]

Equation is simple enough just not sure how to choose it.

Example: Experience level - level adjustment. Essentially (X - Y). But the result can't be lower than one. Help on this one please?

[Jonmo1]

Try

=MAX(1, X-Y)

[Sam Capricci]

I wonder if =MIN(1,X-Y) would work for you?

[JohnboyKGS]

Thanks for the help everyone. The =MAX function worked great. Whats the difference between MIN/MAX? +REP to you both.

[Jonmo1]

You're welcome

MAX returns the largest (Maximum) value of the given values
MIN returns the smallest (Minimum) value of the given values