Would like to do the following for our school,
In cell A1 there is a number, for instance: 12.12345
Based on that number, the 3rd number after the decimal is
If the 3rd number after the decimal is “x” then the contents returned in b2 is a text value ( like
high school ).
12.12145 middle school
12.12245 elementary school
12.12345 high school
12.12445 charter school
12.12545 special education
12.12645 advanced placement
12.12745 athletic departments
12.12845 special placements
12.12945 ais schools
So based on the value 0-9 that is in the 3rd number after the decimal, a text value in
B2 is one of nine choices.
1) The amount of numbers before the decimal point is variable
2) the number of values after the decimal point is equal to or larger than 3.
3) able to change the pivotal value after the decimal from 3 to another value ( say 2nd or 4th )
Your help is