![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
So you want something similar to the following?
IIF(HAVGC1 < HAVGC1.1, 1, IIF(HAVGC2 < HAVGC2.1, 2, IIF(HAVGC3 < HAVGC3.1, 3, IIF(HAVGC4 < HAVGC4.1, 4, IIF(HAVGC5 < HAVGC5.1, 5, IIF(HAVGC6 < HAVGC6.1, 6, IIF(HAVGC7 < HAVGC7.1, 7, IIF(HAVGC8 < HAVGC8.1, 8, IIF(HAVGC9 < HAVGC9.1, 9, IIF(HAVGC10 < HAVGC10.1, 10, IIF(HAVGC11 < HAVGC11.1, 11, IIF(HAVGC12 < HAVGC12.1, 12, IIF(HAVGC13 < HAVGC13.1, 13, IIF(HAVGC14 < HAVGC14.1, 14, IIF(HAVGC15 < HAVGC15.1, 15, IIF(HAVGC16 < HAVGC16.1, 16, IIF(HAVGC17 < HAVGC17.1, 17, IIF(HAVGC18 < HAVGC18.1, 18, IIF(HAVGC19 < HAVGC19.1, 19, IIF(HAVGC20 < HAVGC20.1, 20, IIF(HAVGC21 < HAVGC21.1, 21, IIF(HAVGC22 < HAVGC22.1, 22, IIF(HAVGC23 < HAVGC23.1, 23, IIF(HAVGC24 < HAVGC24.1, 24, IIF(HAVGC25 < HAVGC25.1, 25, IIF(HAVGC26 < HAVGC26.1, 26, IIF(HAVGC27 < HAVGC27.1, 27, IIF(HAVGC28 < HAVGC28.1, 28, IIF(HAVGC29 < HAVGC29.1, 29, IIF(HAVGC30 < HAVGC30.1, 30, IIF(HAVGC31 < HAVGC31.1, 31, IIF(HAVGC32 < HAVGC32.1, 32, IIF(HAVGC33 < HAVGC33.1, 33, IIF(HAVGC34 < HAVGC34.1, 34, IIF(HAVGC35 < HAVGC35.1, 35, IIF(HAVGC36 < HAVGC36.1, 36, IIF(HAVGC37 < HAVGC37.1, 37, IIF(HAVGC38 < HAVGC38.1, 38, IIF(HAVGC39 < HAVGC39.1, 39, IIF(HAVGC40 < HAVGC40.1, 40, IIF(HAVGC41 < HAVGC41.1, 41, IIF(HAVGC42 < HAVGC42.1, 42, IIF(HAVGC43 < HAVGC43.1, 43, IIF(HAVGC44 < HAVGC44.1, 44, IIF(HAVGC45 < HAVGC45.1, 45, IIF(HAVGC46 < HAVGC46.1, 46, IIF(HAVGC47 < HAVGC47.1, 47, IIF(HAVGC48 < HAVGC48.1, 48, IIF(HAVGC49 < HAVGC49.1, 49, IIF(HAVGC50 < HAVGC50.1, 50, IIF(HAVGC51 < HAVGC51.1, 51, IIF(HAVGC52 < HAVGC52.1, 52, IIF(HAVGC53 < HAVGC53.1, 53, IIF(HAVGC54 < HAVGC54.1, 54, IIF(HAVGC55 < HAVGC55.1, 55, IIF(HAVGC56 < HAVGC56.1, 56, IIF(HAVGC57 < HAVGC57.1, 57, IIF(HAVGC58 < HAVGC58.1, 58, IIF(HAVGC59 < HAVGC59.1, 59, IIF(HAVGC60 < HAVGC60.1, 60, IIF(HAVGC61 < HAVGC61.1, 61, IIF(HAVGC62 < HAVGC62.1, 62, IIF(HAVGC63 < HAVGC63.1, 63, IIF(HAVGC64 < HAVGC64.1, 64, IIF(HAVGC65 < HAVGC65.1, 65, IIF(HAVGC66 < HAVGC66.1, 66, IIF(HAVGC67 < HAVGC67.1, 67, IIF(HAVGC68 < HAVGC68.1, 68, IIF(HAVGC69 < HAVGC69.1, 69, IIF(HAVGC70 < HAVGC70.1, 70, IIF(HAVGC71 < HAVGC71.1, 71, IIF(HAVGC72 < HAVGC72.1, 72, IIF(HAVGC73 < HAVGC73.1, 73, IIF(HAVGC74 < HAVGC74.1, 74, IIF(HAVGC75 < HAVGC75.1, 75, IIF(HAVGC76 < HAVGC76.1, 76, IIF(HAVGC77 < HAVGC77.1, 77, IIF(HAVGC78 < HAVGC78.1, 78, IIF(HAVGC79 < HAVGC79.1, 79, IIF(HAVGC80 < HAVGC80.1, 80, IIF(HAVGC81 < HAVGC81.1, 81, IIF(HAVGC82 < HAVGC82.1, 82, IIF(HAVGC83 < HAVGC83.1, 83, IIF(HAVGC84 < HAVGC84.1, 84, IIF(HAVGC85 < HAVGC85.1, 85, IIF(HAVGC86 < HAVGC86.1, 86, IIF(HAVGC87 < HAVGC87.1, 87, IIF(HAVGC88 < HAVGC88.1, 88, IIF(HAVGC89 < HAVGC89.1, 89, IIF(HAVGC90 < HAVGC90.1, 90, IIF(HAVGC91 < HAVGC91.1, 91, IIF(HAVGC92 < HAVGC92.1, 92, IIF(HAVGC93 < HAVGC93.1, 93, IIF(HAVGC94 < HAVGC94.1, 94, IIF(HAVGC95 < HAVGC95.1, 95, IIF(HAVGC96 < HAVGC96.1, 96, IIF(HAVGC97 < HAVGC97.1, 97, IIF(HAVGC98 < HAVGC98.1, 98, IIF(HAVGC99 < HAVGC99.1, 99, IIF(HAVGC100 < HAVGC100.1, 100, IIF(HAVGC101 < HAVGC101.1, 101, IIF(HAVGC102 < HAVGC102.1, 102, IIF(HAVGC103 < HAVGC103.1, 103, IIF(HAVGC104 < HAVGC104.1, 104, IIF(HAVGC105 < HAVGC105.1, 105, IIF(HAVGC106 < HAVGC106.1, 106, IIF(HAVGC107 < HAVGC107.1, 107, IIF(HAVGC108 < HAVGC108.1, 108, IIF(HAVGC109 < HAVGC109.1, 109, IIF(HAVGC110 < HAVGC110.1, 110, IIF(HAVGC111 < HAVGC111.1, 111, IIF(HAVGC112 < HAVGC112.1, 112, IIF(HAVGC113 < HAVGC113.1, 113, IIF(HAVGC114 < HAVGC114.1, 114, IIF(HAVGC115 < HAVGC115.1, 115, IIF(HAVGC116 < HAVGC116.1, 116, IIF(HAVGC117 < HAVGC117.1, 117, IIF(HAVGC118 < HAVGC118.1, 118, IIF(HAVGC119 < HAVGC119.1, 119, IIF(HAVGC120 < HAVGC120.1, 120, IIF(HAVGC121 < HAVGC121.1, 121, IIF(HAVGC122 < HAVGC122.1, 122, IIF(HAVGC123 < HAVGC123.1, 123, IIF(HAVGC124 < HAVGC124.1, 124, IIF(HAVGC125 < HAVGC125.1, 125, IIF(HAVGC126 < HAVGC126.1, 126, IIF(HAVGC127 < HAVGC127.1, 127, IIF(HAVGC128 < HAVGC128.1, 128, IIF(HAVGC129 < HAVGC129.1, 129, IIF(HAVGC130 < HAVGC130.1, 130, IIF(HAVGC131 < HAVGC131.1, 131, IIF(HAVGC132 < HAVGC132.1, 132, IIF(HAVGC133 < HAVGC133.1, 133, IIF(HAVGC134 < HAVGC134.1, 134, IIF(HAVGC135 < HAVGC135.1, 135, IIF(HAVGC136 < HAVGC136.1, 136, IIF(HAVGC137 < HAVGC137.1, 137, IIF(HAVGC138 < HAVGC138.1, 138, IIF(HAVGC139 < HAVGC139.1, 139, IIF(HAVGC140 < HAVGC140.1, 140, IIF(HAVGC141 < HAVGC141.1, 141, IIF(HAVGC142 < HAVGC142.1, 142, IIF(HAVGC143 < HAVGC143.1, 143, IIF(HAVGC144 < HAVGC144.1, 144, IIF(HAVGC145 < HAVGC145.1, 145, IIF(HAVGC146 < HAVGC146.1, 146, IIF(HAVGC147 < HAVGC147.1, 147, IIF(HAVGC148 < HAVGC148.1, 148, IIF(HAVGC149 < HAVGC149.1, 149, IIF(HAVGC150 < HAVGC150.1, 150, IIF(HAVGC151 < HAVGC151.1, 151, IIF(HAVGC152 < HAVGC152.1, 152, IIF(HAVGC153 < HAVGC153.1, 153, IIF(HAVGC154 < HAVGC154.1, 154, IIF(HAVGC155 < HAVGC155.1, 155, IIF(HAVGC156 < HAVGC156.1, 156, IIF(HAVGC157 < HAVGC157.1, 157, IIF(HAVGC158 < HAVGC158.1, 158, IIF(HAVGC159 < HAVGC159.1, 159, IIF(HAVGC160 < HAVGC160.1, 160, IIF(HAVGC161 < HAVGC161.1, 161, IIF(HAVGC162 < HAVGC162.1, 162, IIF(HAVGC163 < HAVGC163.1, 163, IIF(HAVGC164 < HAVGC164.1, 164, IIF(HAVGC165 < HAVGC165.1, 165, IIF(HAVGC166 < HAVGC166.1, 166, IIF(HAVGC167 < HAVGC167.1, 167, IIF(HAVGC168 < HAVGC168.1, 168, IIF(HAVGC169 < HAVGC169.1, 169, IIF(HAVGC170 < HAVGC170.1, 170, IIF(HAVGC171 < HAVGC171.1, 171, IIF(HAVGC172 < HAVGC172.1, 172, IIF(HAVGC173 < HAVGC173.1, 173, IIF(HAVGC174 < HAVGC174.1, 174, IIF(HAVGC175 < HAVGC175.1, 175, IIF(HAVGC176 < HAVGC176.1, 176, IIF(HAVGC177 < HAVGC177.1, 177, IIF(HAVGC178 < HAVGC178.1, 178, IIF(HAVGC179 < HAVGC179.1, 179, IIF(HAVGC180 < HAVGC180.1, 180, IIF(HAVGC181 < HAVGC181.1, 181, IIF(HAVGC182 < HAVGC182.1, 182, IIF(HAVGC183 < HAVGC183.1, 183, IIF(HAVGC184 < HAVGC184.1, 184, IIF(HAVGC185 < HAVGC185.1, 185, IIF(HAVGC186 < HAVGC186.1, 186, IIF(HAVGC187 < HAVGC187.1, 187, IIF(HAVGC188 < HAVGC188.1, 188, IIF(HAVGC189 < HAVGC189.1, 189, IIF(HAVGC190 < HAVGC190.1, 190, IIF(HAVGC191 < HAVGC191.1, 191, IIF(HAVGC192 < HAVGC192.1, 192, IIF(HAVGC193 < HAVGC193.1, 193, IIF(HAVGC194 < HAVGC194.1, 194, IIF(HAVGC195 < HAVGC195.1, 195, IIF(HAVGC196 < HAVGC196.1, 196, IIF(HAVGC197 < HAVGC197.1, 197, IIF(HAVGC198 < HAVGC198.1, 198, IIF(HAVGC199 < HAVGC199.1, 199, IIF(HAVGC200 < HAVGC200.1, 200, IIF(HAVGC201 < HAVGC201.1, 201, IIF(HAVGC202 < HAVGC202.1, 202, IIF(HAVGC203 < HAVGC203.1, 203, IIF(HAVGC204 < HAVGC204.1, 204, IIF(HAVGC205 < HAVGC205.1, 205, IIF(HAVGC206 < HAVGC206.1, 206, IIF(HAVGC207 < HAVGC207.1, 207, IIF(HAVGC208 < HAVGC208.1, 208, IIF(HAVGC209 < HAVGC209.1, 209, IIF(HAVGC210 < HAVGC210.1, 210, IIF(HAVGC211 < HAVGC211.1, 211, IIF(HAVGC212 < HAVGC212.1, 212, IIF(HAVGC213 < HAVGC213.1, 213, IIF(HAVGC214 < HAVGC214.1, 214, IIF(HAVGC215 < HAVGC215.1, 215, IIF(HAVGC216 < HAVGC216.1, 216, IIF(HAVGC217 < HAVGC217.1, 217, IIF(HAVGC218 < HAVGC218.1, 218, IIF(HAVGC219 < HAVGC219.1, 219, IIF(HAVGC220 < HAVGC220.1, 220, IIF(HAVGC221 < HAVGC221.1, 221, IIF(HAVGC222 < HAVGC222.1, 222, IIF(HAVGC223 < HAVGC223.1, 223, IIF(HAVGC224 < HAVGC224.1, 224, IIF(HAVGC225 < HAVGC225.1, 225, IIF(HAVGC226 < HAVGC226.1, 226, IIF(HAVGC227 < HAVGC227.1, 227, IIF(HAVGC228 < HAVGC228.1, 228, IIF(HAVGC229 < HAVGC229.1, 229, IIF(HAVGC230 < HAVGC230.1, 230, IIF(HAVGC231 < HAVGC231.1, 231, IIF(HAVGC232 < HAVGC232.1, 232, IIF(HAVGC233 < HAVGC233.1, 233, IIF(HAVGC234 < HAVGC234.1, 234, IIF(HAVGC235 < HAVGC235.1, 235, IIF(HAVGC236 < HAVGC236.1, 236, IIF(HAVGC237 < HAVGC237.1, 237, IIF(HAVGC238 < HAVGC238.1, 238, IIF(HAVGC239 < HAVGC239.1, 239, IIF(HAVGC240 < HAVGC240.1, 240, IIF(HAVGC241 < HAVGC241.1, 241, IIF(HAVGC242 < HAVGC242.1, 242, IIF(HAVGC243 < HAVGC243.1, 243, IIF(HAVGC244 < HAVGC244.1, 244, IIF(HAVGC245 < HAVGC245.1, 245, IIF(HAVGC246 < HAVGC246.1, 246, IIF(HAVGC247 < HAVGC247.1, 247, IIF(HAVGC248 < HAVGC248.1, 248, IIF(HAVGC249 < HAVGC249.1, 249, IIF(HAVGC250 < HAVGC250.1, 250, IIF(HAVGC251 < HAVGC251.1, 251, IIF(HAVGC252 < HAVGC252.1, 252, IIF(HAVGC253 < HAVGC253.1, 253, IIF(HAVGC254 < HAVGC254.1, 254, IIF(HAVGC255 < HAVGC255.1, 255, IIF(HAVGC256 < HAVGC256.1, 256, IIF(HAVGC257 < HAVGC257.1, 257, IIF(HAVGC258 < HAVGC258.1, 258, IIF(HAVGC259 < HAVGC259.1, 259, IIF(HAVGC260 < HAVGC260.1, 260, IIF(HAVGC261 < HAVGC261.1, 261, IIF(HAVGC262 < HAVGC262.1, 262, IIF(HAVGC263 < HAVGC263.1, 263, IIF(HAVGC264 < HAVGC264.1, 264, IIF(HAVGC265 < HAVGC265.1, 265, IIF(HAVGC266 < HAVGC266.1, 266, IIF(HAVGC267 < HAVGC267.1, 267, IIF(HAVGC268 < HAVGC268.1, 268, IIF(HAVGC269 < HAVGC269.1, 269, IIF(HAVGC270 < HAVGC270.1, 270, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|