In your case, if the INWeight is less than or equal to 499, then the Case statement exits with a result of .49. Otherwise the statement moves on to the next case. The last line in your Case statement is your default

In your case, if the INWeight is less than or equal to 499, then the Case statement exits with a result of .49. Otherwise the statement moves on to the next case. The last line in your Case statement is your default

It's a good idea to use a table look up even if it's a small number of values, if those values might be subject to change in the future. We all have better things to do than redefine a calculation when someone else in the organization can just go in and edit a table to make the same change.