# 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.

"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.

Regards,

Alan