I am having trouble creating a simple IF-THEN statement that will yield a text description of a number field. This is a common Excel formula and it may be easiest to show how I'd write in it Excel:

 

 

This formula looks up the number in Number_Field and writes, in another column, whether that number is "Under 100," "Equal to 100" etc.

 

Is there a way to do this using the built in formula generator in the Forms View - or a way to do it in Free Flow script on an HTML view? I've poked around and tried some things from the forums but have not found a working example.