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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.