I would prefer to do this with an IFF statement as it would be the easiest way for me to continue with the project.

Here is what I need. in a table will be a number. based on that number three values can arrise, we will call that number x and the threshold will be y and the resulting value will be z

Here are the three resulting values

if X is less than Y, then Z will equal a calculation based on a certain value
if X is equal to Y then Z equals 0
if X is greater than Y then Z equals 50