Jack Naylor PE
Technical User
Have been creating In Game tools based upon Lotus 1-2-3 SS. Most of the Crafting Formulas are straight forward but some require whole numbers. What I need to do with the answer in a cell is:
For < 0.2500 show 0
From 0.2500 to < 0.5000 show 1
From 0.5000 to < 0.7500 show 2
From 0.7500 to 1.000 show 3
For < 0.2500 show 0
From 0.2500 to < 0.5000 show 1
From 0.5000 to < 0.7500 show 2
From 0.7500 to 1.000 show 3