TomCei11Copper ContributorJul 24, 20208 bit binary series fillhello all. I'm working with FANUC PMC/PLC stuff. I am trying to make a fancy Input Output sheet. PMC uses 000.0 format. Range from 0000.0 to 0000.7 until the whole number flips (to 0001.0 then). I am ...Show More
mtarlerSilver ContributorJul 24, 2020TomCei11 I don't see a series fill working on that "interesting" system but a simple formula would work. A1 = 0.1 then A2 = =IF(ROUND(MOD(A1,1),1)=0.7,A1+0.3,A1+0.1)and fill down. (glad I tested it as I needed to add that ROUND() due to floating point error)
