AnsweredAssumed Answered

Yes (yet?) another IIF question...

Question asked by Alan Stoldt on Jul 14, 2011
Latest reply on Jul 14, 2011 by Jason Capriotti

I have a set of Equations happening on a Bearing Rail, everything is going well. Change the length, and the number of mounting hole Instances update accordingly. The Offset from the end is determined by the overall length / hole pitch. (60.0mm Hole Pitch.)


The Linear Pattern explodes on me though if an OAL value is entered that is divisable by sixty without a remainder.


"A"=  INT("OAL@PROFILE RAIL"/60) (=# of 60mm Pitches, A+1 = Number of Instances)


"B" is the Remainder. If "B" is less than 8.5, the afore mentioned Explosion occurs.


"C" is an adder.


"NUMBER OF HOLES@LPattern1"  =   "A"  + "1"


"NUMBER OF HOLES@LPattern1"  =   "A"  + "C"


If "B" is Less Than 8.5 "C" should be set to 0, if 8.5 or Greater "C" should be set to 1.


(IIF "B" < 8.5,"C"=0,"C"=1)


Above is the Equation I came up with.


1.) Can I do this with the IIF statement?

2.) What is right or what am I doing wrong.


Before post hogs swarm and tell me to search or give countless references I've already looked at, yes, I already have, thank you very much, don't bother.


Those with concrete examples or suggestions, Thank You.