• Download software • Tutorial videos
• Subscription & data-feed pricing • Class schedule


• New account application • Trading resources
• Margin rates • Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » Price relation to Cloud

Price relation to Cloud Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Tuesday, September 4, 2018 12:59:50 AM
Registered User
Joined: 3/10/2012
Posts: 465

Hi Bruce 

now that we know that via tc mail you can send the charts with overlay of formulas on price

so wondering can you please make ichimoku cloud chart with following conditions and tc mail me,, also if possible to have a template something to work with other overlays and formulas

1) If current price above cloud then GREEN colour  for candles 

2) if current price within cloud  then YELLOW colour or candles

3) if current price below cloud  then RED colour for candles

I want to add few more colours with criterias and with conditions so thats why wondering if there is a template possible ?

thanks 

 
Back to top
Bruce_L
Posted : Tuesday, September 4, 2018 1:46:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I have sent you something but I can't figure out any way to make the Ichimoku Cloud itself look right. It gets interrupted by the technique used to paint the price bars, so there are black histogram bars interfering with the way the Ichimoku Cloud should actually appear.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Wednesday, September 5, 2018 12:27:06 AM
Registered User
Joined: 3/10/2012
Posts: 465

Thanks Bruce that black histogram does not bother me, as I slide the ichimoku cloud to the left so its fine the painted bars gives enough visual to work on them

And is there a template possible to receive so i can add chikou and future cloud conditions as painted bar 4 th and 5 th colours?

regards
Back to top
Bruce_L
Posted : Wednesday, September 5, 2018 10:41:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The formulas for the various components at the points most likely of interest are in the following topic.

Ichimoku Cloud

The basic format of the Custom PCF Indicator used to plot a particular color is the following to paint the to the top of the bodies of the candles.

IIF(your condition here, GREATEST(O, C), 1 / 0)

These all have to appear before the black histogram which plots to the bottom of the body.

LEAST(O, C)

If you want to highlight the entire range of the candle instead of just the body, the Custom PCF Indicator to paint the color would be:

IIF(your conidtion here, H, 1 / 0)

And the formula for the black histogram which plots to the bottom of the body would just be:

L

And the OHLC indicator is generally going to be the last thing plotted in the pane. You might want to move it to another pane and then overlay it back it the same pane and scale as price instead of trying to make the OHLC indicator from scratch.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Wednesday, September 5, 2018 11:35:01 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce trying as per your instructions why is it showing error(sayng syntax error near AND , what wrong in my formula below 

IIF(GREATEST((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4, (MAXH52.26 + MINL52.26) / 2) < C, AND C > O AND C > C26 , GREATEST(O, C), 1 / 0)

 

And second question can we plot fractal dots on chikou ? 
Back to top
Bruce_L
Posted : Wednesday, September 5, 2018 12:35:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You shouldn't have that comma right before where you added your formula. That comma is part of the structure of the IIF() function and not part of "your formula here".

IIF(GREATEST((MAXH9.26 + MINL9.26 + MAXH26.26 + MINL26.26) / 4, (MAXH52.26 + MINL52.26) / 2) < C AND C > O AND C > C26 , GREATEST(O, C), 1 / 0)

I can't think of a reason you couldn' plot the dots on the Lagging Span (Chikou Span). It is pretty much just going to be the following for the fractal highs.

IIF(MAXC2 < C2 AND C2 > MAXC2.3, C2, 0)

And the following for the fractal lows.

IIF(MINC2 > C2 AND C2 < MINC2.3, C2, 0)

You are just going to have a 1-period moving average of both Custom PCF Indicators offset by -28 bars to get the fractal dots into the correct positions.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Wednesday, September 5, 2018 1:03:40 PM
Registered User
Joined: 3/10/2012
Posts: 465

Thank you Bruce the Fractal part works perfect...

but the formula for painted bar how do i make it only appear overaly the candle body because presently its plotting histogram from bottom of screen when i scale it with price so what to change or add ?

 
Back to top
Bruce_L
Posted : Wednesday, September 5, 2018 1:07:48 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The basic format of the Custom PCF Indicator used to plot a particular color is the following to paint the to the top of the bodies of the candles.

IIF(your condition here, GREATEST(O, C), 1 / 0)

These all have to appear before the black histogram which plots to the bottom of the body.

LEAST(O, C)

A far more detailed description of the technique appears in my Wednesday, February 14, 2018 11:38:01 AM post in the Elder Impulse topic. There are a lot of parts required to make this work and look even close to correct.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Wednesday, September 5, 2018 1:30:00 PM
Registered User
Joined: 3/10/2012
Posts: 465

Sorry Bruce i can see what u mean ,, but by default when i click on the labels that u made Above , within below and i click add plot here , then i click custom pcf  indicator so by default it plots past the black histogram 

I even tried clicking price and then clicking add plot here but by default it plots past the Black histogram label

so how to fix that 
Back to top
Bruce_L
Posted : Wednesday, September 5, 2018 1:37:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You could move the B (the black histogram) and OHLC indicators into a pane and then move them back once you have added your indicators.

Another option would be to remove and then re-create the B (the black histogram) and OHLC indicators from scratch.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Wednesday, September 5, 2018 1:54:13 PM
Registered User
Joined: 3/10/2012
Posts: 465

Ok that works Perfect... 

thanks again 

Cheers
Back to top
dhirenshah
Posted : Monday, September 10, 2018 3:13:06 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce from your response of 05 September 2018 12:35:05 

I can't think of a reason you couldn' plot the dots on the Lagging Span (Chikou Span). It is pretty much just going to be the following for the fractal highs.

IIF(MAXC2 < C2 AND C2 > MAXC2.3, C2, 0)

And the following for the fractal lows.

IIF(MINC2 > C2 AND C2 < MINC2.3, C2, 0)

You are just going to have a 1-period moving average of both Custom PCF Indicators offset by -28 bars to get the fractal dots into the correct positions.

So my question is that below formula you did for me which produces accurate results for current price crossing up the most recent fractal high , so can you please modify the formula to get same info for CHIKOU ,where current chikou CROSSING UP MOST RECENT FRACTAL CHIKOU CLOSE PLOTTED ON CHIKOU EXAMPLE : "HD" ON 130 MIN CHART WHERE CHIKOU CROSSES UP THE MOST RECENT FRACTAL CHIKOU CLOSE 

C > IIF(MAXH2 < H2 AND H2 > MAXH2.3, C, IIF(MAXH2.1 < H3 AND H3 > MAXH2.4, H3, IIF(MAXH2.2 < H4 AND H4 > MAXH2.5, IIF(C1 < H4, H4, C), IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, IIF(MAXC2.1 < H5, H5, C), IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, IIF(MAXC3.1 < H6, H6, C), IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, IIF(MAXC4.1 < H7, H7, C), IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, IIF(MAXC5.1 < H8, H8, C), IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, IIF(MAXC6.1 < H9, H9, C), IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, IIF(MAXC7.1 < H10, H10, C), IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, IIF(MAXC8.1 < H11, H11, C), IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, IIF(MAXC9.1 < H12, H12, C), IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, IIF(MAXC10.1 < H13, H13, C), IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, IIF(MAXC11.1 < H14, H14, C), IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, IIF(MAXC12.1 < H15, H15, C), IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, IIF(MAXC13.1 < H16, H16, C), IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, IIF(MAXC14.1 < H17, H17, C), IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, IIF(MAXC15.1 < H18, H18, C), IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, IIF(MAXC16.1 < H19, H19, C), IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, IIF(MAXC17.1 < H20, H20, C), IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, IIF(MAXC18.1 < H21, H21, C), IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, IIF(MAXC19.1 < H22, H22, C), IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, IIF(MAXC20.1 < H23, H23, C), IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, IIF(MAXC21.1 < H24, H24, C), IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, IIF(MAXC22.1 < H25, H25, C), IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, IIF(MAXC23.1 < H26, H26, C), IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, IIF(MAXC24.1 < H27, H27, C), IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, IIF(MAXC25.1 < H28, H28, C), IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, IIF(MAXC26.1 < H29, H29, C), IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, IIF(MAXC27.1 < H30, H30, C), IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, IIF(MAXC28.1 < H31, H31, C), IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, IIF(MAXC29.1 < H32, H32, C), IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, IIF(MAXC30.1 < H33, H33, C), IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, IIF(MAXC31.1 < H34, H34, C), IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, IIF(MAXC32.1 < H35, H35, C), IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, IIF(MAXC33.1 < H36, H36, C), IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, IIF(MAXC34.1 < H37, H37, C), IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, IIF(MAXC35.1 < H38, H38, C), IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, IIF(MAXC36.1 < H39, H39, C), IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, IIF(MAXC37.1 < H40, H40, C), IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, IIF(MAXC38.1 < H41, H41, C), IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, IIF(MAXC39.1 < H42, H42, C), IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, IIF(MAXC40.1 < H43, H43, C), IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, IIF(MAXC41.1 < H44, H44, C), IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, IIF(MAXC42.1 < H45, H45, C), IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, IIF(MAXC43.1 < H46, H46, C), IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, IIF(MAXC44.1 < H47, H47, C), IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, IIF(MAXC45.1 < H48, H48, C), IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, IIF(MAXC46.1 < H49, H49, C), IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, IIF(MAXC47.1 < H50, H50, C), IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, IIF(MAXC48.1 < H51, H51, C), IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, IIF(MAXC49.1 < H52, H52, C), IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, IIF(MAXC50.1 < H53, H53, C), IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, IIF(MAXC51.1 < H54, H54, C), IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, IIF(MAXC52.1 < H55, H55, C), IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, IIF(MAXC53.1 < H56, H56, C), IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, IIF(MAXC54.1 < H57, H57, C), IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, IIF(MAXC55.1 < H58, H58, C), IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, IIF(MAXC56.1 < H59, H59, C), IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, IIF(MAXC57.1 < H60, H60, C), IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, IIF(MAXC58.1 < H61, H61, C), IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, IIF(MAXC59.1 < H62, H62, C), IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, IIF(MAXC60.1 < H63, H63, C), IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, IIF(MAXC61.1 < H64, H64, C), IIF(MAXH2.63 < H65 AND H65 > MAXH2.66, IIF(MAXC62.1 < H65, H65, C), IIF(MAXH2.64 < H66 AND H66 > MAXH2.67, IIF(MAXC63.1 < H66, H66, C), IIF(MAXH2.65 < H67 AND H67 > MAXH2.68, IIF(MAXC64.1 < H67, H67, C), IIF(MAXH2.66 < H68 AND H68 > MAXH2.69, IIF(MAXC65.1 < H68, H68, C), IIF(MAXH2.67 < H69 AND H69 > MAXH2.70, IIF(MAXC66.1 < H69, H69, C), IIF(MAXH2.68 < H70 AND H70 > MAXH2.71, IIF(MAXC67.1 < H70, H70, C), IIF(MAXH2.69 < H71 AND H71 > MAXH2.72, IIF(MAXC68.1 < H71, H71, C), IIF(MAXH2.70 < H72 AND H72 > MAXH2.73, IIF(MAXC69.1 < H72, H72, C), IIF(MAXH2.71 < H73 AND H73 > MAXH2.74, IIF(MAXC70.1 < H73, H73, C), IIF(MAXH2.72 < H74 AND H74 > MAXH2.75, IIF(MAXC71.1 < H74, H74, C), IIF(MAXH2.73 < H75 AND H75 > MAXH2.76, IIF(MAXC72.1 < H75, H75, C), IIF(MAXH2.74 < H76 AND H76 > MAXH2.77, IIF(MAXC73.1 < H76, H76, C), IIF(MAXH2.75 < H77 AND H77 > MAXH2.78, IIF(MAXC74.1 < H77, H77, C), IIF(MAXH2.76 < H78 AND H78 > MAXH2.79, IIF(MAXC75.1 < H78, H78, C), IIF(MAXH2.77 < H79 AND H79 > MAXH2.80, IIF(MAXC76.1 < H79, H79, C), IIF(MAXH2.78 < H80 AND H80 > MAXH2.81, IIF(MAXC77.1 < H80, H80, C), IIF(MAXH2.79 < H81 AND H81 > MAXH2.82, IIF(MAXC78.1 < H81, H81, C), IIF(MAXH2.80 < H82 AND H82 > MAXH2.83, IIF(MAXC79.1 < H82, H82, C), IIF(MAXH2.81 < H83 AND H83 > MAXH2.84, IIF(MAXC80.1 < H83, H83, C), IIF(MAXH2.82 < H84 AND H84 > MAXH2.85, IIF(MAXC81.1 < H84, H84, C), IIF(MAXH2.83 < H85 AND H85 > MAXH2.86, IIF(MAXC82.1 < H85, H85, C), IIF(MAXH2.84 < H86 AND H86 > MAXH2.87, IIF(MAXC83.1 < H86, H86, C), IIF(MAXH2.85 < H87 AND H87 > MAXH2.88, IIF(MAXC84.1 < H87, H87, C), IIF(MAXH2.86 < H88 AND H88 > MAXH2.89, IIF(MAXC85.1 < H88, H88, C), IIF(MAXH2.87 < H89 AND H89 > MAXH2.90, IIF(MAXC86.1 < H89, H89, C), IIF(MAXH2.88 < H90 AND H90 > MAXH2.91, IIF(MAXC87.1 < H90, H90, C), IIF(MAXH2.89 < H91 AND H91 > MAXH2.92, IIF(MAXC88.1 < H91, H91, C), IIF(MAXH2.90 < H92 AND H92 > MAXH2.93, IIF(MAXC89.1 < H92, H92, C), IIF(MAXH2.91 < H93 AND H93 > MAXH2.94, IIF(MAXC90.1 < H93, H93, C), IIF(MAXH2.92 < H94 AND H94 > MAXH2.95, IIF(MAXC91.1 < H94, H94, C), IIF(MAXH2.93 < H95 AND H95 > MAXH2.96, IIF(MAXC92.1 < H95, H95, C), IIF(MAXH2.94 < H96 AND H96 > MAXH2.97, IIF(MAXC93.1 < H96, H96, C), IIF(MAXH2.95 < H97 AND H97 > MAXH2.98, IIF(MAXC94.1 < H97, H97, C), IIF(MAXH2.96 < H98 AND H98 > MAXH2.99, IIF(MAXC95.1 < H98, H98, C), IIF(MAXH2.97 < H99 AND H99 > MAXH2.100, IIF(MAXC96.1 < H99, H99, C), IIF(MAXH2.98 < H100 AND H100 > MAXH2.101, IIF(MAXC97.1 < H100, H100, C), IIF(MAXH2.99 < H101 AND H101 > MAXH2.102, IIF(MAXC98.1 < H101, H101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

 

and this is for the fractal low that you did and i need same for chikou close today below the chikou fractal close of past EXAMPLE : AMZN ON 130 MIN CHART CURRENT CHIKOU CLOSE BELOW MOST RECENT FRACTAL CHIKOU CLOSE OF PAST

C < IIF(MINL2 > L2 AND L2 < MINL2.3, C, IIF(MINL2.1 > L3 AND L3 < MINL2.4, L3, IIF(MINL2.2 > L4 AND L4 < MINL2.5, IIF(C1 > L4, L4, C), IIF(MINL2.3 > L5 AND L5 < MINL2.6, IIF(MINC2.1 > L5, L5, C), IIF(MINL2.4 > L6 AND L6 < MINL2.7, IIF(MINC3.1 > L6, L6, C), IIF(MINL2.5 > L7 AND L7 < MINL2.8, IIF(MINC4.1 > L7, L7, C), IIF(MINL2.6 > L8 AND L8 < MINL2.9, IIF(MINC5.1 > L8, L8, C), IIF(MINL2.7 > L9 AND L9 < MINL2.10, IIF(MINC6.1 > L9, L9, C), IIF(MINL2.8 > L10 AND L10 < MINL2.11, IIF(MINC7.1 > L10, L10, C), IIF(MINL2.9 > L11 AND L11 < MINL2.12, IIF(MINC8.1 > L11, L11, C), IIF(MINL2.10 > L12 AND L12 < MINL2.13, IIF(MINC9.1 > L12, L12, C), IIF(MINL2.11 > L13 AND L13 < MINL2.14, IIF(MINC10.1 > L13, L13, C), IIF(MINL2.12 > L14 AND L14 < MINL2.15, IIF(MINC11.1 > L14, L14, C), IIF(MINL2.13 > L15 AND L15 < MINL2.16, IIF(MINC12.1 > L15, L15, C), IIF(MINL2.14 > L16 AND L16 < MINL2.17, IIF(MINC13.1 > L16, L16, C), IIF(MINL2.15 > L17 AND L17 < MINL2.18, IIF(MINC14.1 > L17, L17, C), IIF(MINL2.16 > L18 AND L18 < MINL2.19, IIF(MINC15.1 > L18, L18, C), IIF(MINL2.17 > L19 AND L19 < MINL2.20, IIF(MINC16.1 > L19, L19, C), IIF(MINL2.18 > L20 AND L20 < MINL2.21, IIF(MINC17.1 > L20, L20, C), IIF(MINL2.19 > L21 AND L21 < MINL2.22, IIF(MINC18.1 > L21, L21, C), IIF(MINL2.20 > L22 AND L22 < MINL2.23, IIF(MINC19.1 > L22, L22, C), IIF(MINL2.21 > L23 AND L23 < MINL2.24, IIF(MINC20.1 > L23, L23, C), IIF(MINL2.22 > L24 AND L24 < MINL2.25, IIF(MINC21.1 > L24, L24, C), IIF(MINL2.23 > L25 AND L25 < MINL2.26, IIF(MINC22.1 > L25, L25, C), IIF(MINL2.24 > L26 AND L26 < MINL2.27, IIF(MINC23.1 > L26, L26, C), IIF(MINL2.25 > L27 AND L27 < MINL2.28, IIF(MINC24.1 > L27, L27, C), IIF(MINL2.26 > L28 AND L28 < MINL2.29, IIF(MINC25.1 > L28, L28, C), IIF(MINL2.27 > L29 AND L29 < MINL2.30, IIF(MINC26.1 > L29, L29, C), IIF(MINL2.28 > L30 AND L30 < MINL2.31, IIF(MINC27.1 > L30, L30, C), IIF(MINL2.29 > L31 AND L31 < MINL2.32, IIF(MINC28.1 > L31, L31, C), IIF(MINL2.30 > L32 AND L32 < MINL2.33, IIF(MINC29.1 > L32, L32, C), IIF(MINL2.31 > L33 AND L33 < MINL2.34, IIF(MINC30.1 > L33, L33, C), IIF(MINL2.32 > L34 AND L34 < MINL2.35, IIF(MINC31.1 > L34, L34, C), IIF(MINL2.33 > L35 AND L35 < MINL2.36, IIF(MINC32.1 > L35, L35, C), IIF(MINL2.34 > L36 AND L36 < MINL2.37, IIF(MINC33.1 > L36, L36, C), IIF(MINL2.35 > L37 AND L37 < MINL2.38, IIF(MINC34.1 > L37, L37, C), IIF(MINL2.36 > L38 AND L38 < MINL2.39, IIF(MINC35.1 > L38, L38, C), IIF(MINL2.37 > L39 AND L39 < MINL2.40, IIF(MINC36.1 > L39, L39, C), IIF(MINL2.38 > L40 AND L40 < MINL2.41, IIF(MINC37.1 > L40, L40, C), IIF(MINL2.39 > L41 AND L41 < MINL2.42, IIF(MINC38.1 > L41, L41, C), IIF(MINL2.40 > L42 AND L42 < MINL2.43, IIF(MINC39.1 > L42, L42, C), IIF(MINL2.41 > L43 AND L43 < MINL2.44, IIF(MINC40.1 > L43, L43, C), IIF(MINL2.42 > L44 AND L44 < MINL2.45, IIF(MINC41.1 > L44, L44, C), IIF(MINL2.43 > L45 AND L45 < MINL2.46, IIF(MINC42.1 > L45, L45, C), IIF(MINL2.44 > L46 AND L46 < MINL2.47, IIF(MINC43.1 > L46, L46, C), IIF(MINL2.45 > L47 AND L47 < MINL2.48, IIF(MINC44.1 > L47, L47, C), IIF(MINL2.46 > L48 AND L48 < MINL2.49, IIF(MINC45.1 > L48, L48, C), IIF(MINL2.47 > L49 AND L49 < MINL2.50, IIF(MINC46.1 > L49, L49, C), IIF(MINL2.48 > L50 AND L50 < MINL2.51, IIF(MINC47.1 > L50, L50, C), IIF(MINL2.49 > L51 AND L51 < MINL2.52, IIF(MINC48.1 > L51, L51, C), IIF(MINL2.50 > L52 AND L52 < MINL2.53, IIF(MINC49.1 > L52, L52, C), IIF(MINL2.51 > L53 AND L53 < MINL2.54, IIF(MINC50.1 > L53, L53, C), IIF(MINL2.52 > L54 AND L54 < MINL2.55, IIF(MINC51.1 > L54, L54, C), IIF(MINL2.53 > L55 AND L55 < MINL2.56, IIF(MINC52.1 > L55, L55, C), IIF(MINL2.54 > L56 AND L56 < MINL2.57, IIF(MINC53.1 > L56, L56, C), IIF(MINL2.55 > L57 AND L57 < MINL2.58, IIF(MINC54.1 > L57, L57, C), IIF(MINL2.56 > L58 AND L58 < MINL2.59, IIF(MINC55.1 > L58, L58, C), IIF(MINL2.57 > L59 AND L59 < MINL2.60, IIF(MINC56.1 > L59, L59, C), IIF(MINL2.58 > L60 AND L60 < MINL2.61, IIF(MINC57.1 > L60, L60, C), IIF(MINL2.59 > L61 AND L61 < MINL2.62, IIF(MINC58.1 > L61, L61, C), IIF(MINL2.60 > L62 AND L62 < MINL2.63, IIF(MINC59.1 > L62, L62, C), IIF(MINL2.61 > L63 AND L63 < MINL2.64, IIF(MINC60.1 > L63, L63, C), IIF(MINL2.62 > L64 AND L64 < MINL2.65, IIF(MINC61.1 > L64, L64, C), IIF(MINL2.63 > L65 AND L65 < MINL2.66, IIF(MINC62.1 > L65, L65, C), IIF(MINL2.64 > L66 AND L66 < MINL2.67, IIF(MINC63.1 > L66, L66, C), IIF(MINL2.65 > L67 AND L67 < MINL2.68, IIF(MINC64.1 > L67, L67, C), IIF(MINL2.66 > L68 AND L68 < MINL2.69, IIF(MINC65.1 > L68, L68, C), IIF(MINL2.67 > L69 AND L69 < MINL2.70, IIF(MINC66.1 > L69, L69, C), IIF(MINL2.68 > L70 AND L70 < MINL2.71, IIF(MINC67.1 > L70, L70, C), IIF(MINL2.69 > L71 AND L71 < MINL2.72, IIF(MINC68.1 > L71, L71, C), IIF(MINL2.70 > L72 AND L72 < MINL2.73, IIF(MINC69.1 > L72, L72, C), IIF(MINL2.71 > L73 AND L73 < MINL2.74, IIF(MINC70.1 > L73, L73, C), IIF(MINL2.72 > L74 AND L74 < MINL2.75, IIF(MINC71.1 > L74, L74, C), IIF(MINL2.73 > L75 AND L75 < MINL2.76, IIF(MINC72.1 > L75, L75, C), IIF(MINL2.74 > L76 AND L76 < MINL2.77, IIF(MINC73.1 > L76, L76, C), IIF(MINL2.75 > L77 AND L77 < MINL2.78, IIF(MINC74.1 > L77, L77, C), IIF(MINL2.76 > L78 AND L78 < MINL2.79, IIF(MINC75.1 > L78, L78, C), IIF(MINL2.77 > L79 AND L79 < MINL2.80, IIF(MINC76.1 > L79, L79, C), IIF(MINL2.78 > L80 AND L80 < MINL2.81, IIF(MINC77.1 > L80, L80, C), IIF(MINL2.79 > L81 AND L81 < MINL2.82, IIF(MINC78.1 > L81, L81, C), IIF(MINL2.80 > L82 AND L82 < MINL2.83, IIF(MINC79.1 > L82, L82, C), IIF(MINL2.81 > L83 AND L83 < MINL2.84, IIF(MINC80.1 > L83, L83, C), IIF(MINL2.82 > L84 AND L84 < MINL2.85, IIF(MINC81.1 > L84, L84, C), IIF(MINL2.83 > L85 AND L85 < MINL2.86, IIF(MINC82.1 > L85, L85, C), IIF(MINL2.84 > L86 AND L86 < MINL2.87, IIF(MINC83.1 > L86, L86, C), IIF(MINL2.85 > L87 AND L87 < MINL2.88, IIF(MINC84.1 > L87, L87, C), IIF(MINL2.86 > L88 AND L88 < MINL2.89, IIF(MINC85.1 > L88, L88, C), IIF(MINL2.87 > L89 AND L89 < MINL2.90, IIF(MINC86.1 > L89, L89, C), IIF(MINL2.88 > L90 AND L90 < MINL2.91, IIF(MINC87.1 > L90, L90, C), IIF(MINL2.89 > L91 AND L91 < MINL2.92, IIF(MINC88.1 > L91, L91, C), IIF(MINL2.90 > L92 AND L92 < MINL2.93, IIF(MINC89.1 > L92, L92, C), IIF(MINL2.91 > L93 AND L93 < MINL2.94, IIF(MINC90.1 > L93, L93, C), IIF(MINL2.92 > L94 AND L94 < MINL2.95, IIF(MINC91.1 > L94, L94, C), IIF(MINL2.93 > L95 AND L95 < MINL2.96, IIF(MINC92.1 > L95, L95, C), IIF(MINL2.94 > L96 AND L96 < MINL2.97, IIF(MINC93.1 > L96, L96, C), IIF(MINL2.95 > L97 AND L97 < MINL2.98, IIF(MINC94.1 > L97, L97, C), IIF(MINL2.96 > L98 AND L98 < MINL2.99, IIF(MINC95.1 > L98, L98, C), IIF(MINL2.97 > L99 AND L99 < MINL2.100, IIF(MINC96.1 > L99, L99, C), IIF(MINL2.98 > L100 AND L100 < MINL2.101, IIF(MINC97.1 > L100, L100, C), IIF(MINL2.99 > L101 AND L101 < MINL2.102, IIF(MINC98.1 > L101, L101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
thanks Bruce 
 
 
Back to top
Bruce_L
Posted : Monday, September 10, 2018 4:58:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Maybe replace all instances of H in the first formula with C?

C > IIF(MAXC2 < C2 AND C2 > MAXC2.3, C, IIF(MAXC2.1 < C3 AND C3 > MAXC2.4, C3, IIF(MAXC2.2 < C4 AND C4 > MAXC2.5, IIF(C1 < C4, C4, C), IIF(MAXC2.3 < C5 AND C5 > MAXC2.6, IIF(MAXC2.1 < C5, C5, C), IIF(MAXC2.4 < C6 AND C6 > MAXC2.7, IIF(MAXC3.1 < C6, C6, C), IIF(MAXC2.5 < C7 AND C7 > MAXC2.8, IIF(MAXC4.1 < C7, C7, C), IIF(MAXC2.6 < C8 AND C8 > MAXC2.9, IIF(MAXC5.1 < C8, C8, C), IIF(MAXC2.7 < C9 AND C9 > MAXC2.10, IIF(MAXC6.1 < C9, C9, C), IIF(MAXC2.8 < C10 AND C10 > MAXC2.11, IIF(MAXC7.1 < C10, C10, C), IIF(MAXC2.9 < C11 AND C11 > MAXC2.12, IIF(MAXC8.1 < C11, C11, C), IIF(MAXC2.10 < C12 AND C12 > MAXC2.13, IIF(MAXC9.1 < C12, C12, C), IIF(MAXC2.11 < C13 AND C13 > MAXC2.14, IIF(MAXC10.1 < C13, C13, C), IIF(MAXC2.12 < C14 AND C14 > MAXC2.15, IIF(MAXC11.1 < C14, C14, C), IIF(MAXC2.13 < C15 AND C15 > MAXC2.16, IIF(MAXC12.1 < C15, C15, C), IIF(MAXC2.14 < C16 AND C16 > MAXC2.17, IIF(MAXC13.1 < C16, C16, C), IIF(MAXC2.15 < C17 AND C17 > MAXC2.18, IIF(MAXC14.1 < C17, C17, C), IIF(MAXC2.16 < C18 AND C18 > MAXC2.19, IIF(MAXC15.1 < C18, C18, C), IIF(MAXC2.17 < C19 AND C19 > MAXC2.20, IIF(MAXC16.1 < C19, C19, C), IIF(MAXC2.18 < C20 AND C20 > MAXC2.21, IIF(MAXC17.1 < C20, C20, C), IIF(MAXC2.19 < C21 AND C21 > MAXC2.22, IIF(MAXC18.1 < C21, C21, C), IIF(MAXC2.20 < C22 AND C22 > MAXC2.23, IIF(MAXC19.1 < C22, C22, C), IIF(MAXC2.21 < C23 AND C23 > MAXC2.24, IIF(MAXC20.1 < C23, C23, C), IIF(MAXC2.22 < C24 AND C24 > MAXC2.25, IIF(MAXC21.1 < C24, C24, C), IIF(MAXC2.23 < C25 AND C25 > MAXC2.26, IIF(MAXC22.1 < C25, C25, C), IIF(MAXC2.24 < C26 AND C26 > MAXC2.27, IIF(MAXC23.1 < C26, C26, C), IIF(MAXC2.25 < C27 AND C27 > MAXC2.28, IIF(MAXC24.1 < C27, C27, C), IIF(MAXC2.26 < C28 AND C28 > MAXC2.29, IIF(MAXC25.1 < C28, C28, C), IIF(MAXC2.27 < C29 AND C29 > MAXC2.30, IIF(MAXC26.1 < C29, C29, C), IIF(MAXC2.28 < C30 AND C30 > MAXC2.31, IIF(MAXC27.1 < C30, C30, C), IIF(MAXC2.29 < C31 AND C31 > MAXC2.32, IIF(MAXC28.1 < C31, C31, C), IIF(MAXC2.30 < C32 AND C32 > MAXC2.33, IIF(MAXC29.1 < C32, C32, C), IIF(MAXC2.31 < C33 AND C33 > MAXC2.34, IIF(MAXC30.1 < C33, C33, C), IIF(MAXC2.32 < C34 AND C34 > MAXC2.35, IIF(MAXC31.1 < C34, C34, C), IIF(MAXC2.33 < C35 AND C35 > MAXC2.36, IIF(MAXC32.1 < C35, C35, C), IIF(MAXC2.34 < C36 AND C36 > MAXC2.37, IIF(MAXC33.1 < C36, C36, C), IIF(MAXC2.35 < C37 AND C37 > MAXC2.38, IIF(MAXC34.1 < C37, C37, C), IIF(MAXC2.36 < C38 AND C38 > MAXC2.39, IIF(MAXC35.1 < C38, C38, C), IIF(MAXC2.37 < C39 AND C39 > MAXC2.40, IIF(MAXC36.1 < C39, C39, C), IIF(MAXC2.38 < C40 AND C40 > MAXC2.41, IIF(MAXC37.1 < C40, C40, C), IIF(MAXC2.39 < C41 AND C41 > MAXC2.42, IIF(MAXC38.1 < C41, C41, C), IIF(MAXC2.40 < C42 AND C42 > MAXC2.43, IIF(MAXC39.1 < C42, C42, C), IIF(MAXC2.41 < C43 AND C43 > MAXC2.44, IIF(MAXC40.1 < C43, C43, C), IIF(MAXC2.42 < C44 AND C44 > MAXC2.45, IIF(MAXC41.1 < C44, C44, C), IIF(MAXC2.43 < C45 AND C45 > MAXC2.46, IIF(MAXC42.1 < C45, C45, C), IIF(MAXC2.44 < C46 AND C46 > MAXC2.47, IIF(MAXC43.1 < C46, C46, C), IIF(MAXC2.45 < C47 AND C47 > MAXC2.48, IIF(MAXC44.1 < C47, C47, C), IIF(MAXC2.46 < C48 AND C48 > MAXC2.49, IIF(MAXC45.1 < C48, C48, C), IIF(MAXC2.47 < C49 AND C49 > MAXC2.50, IIF(MAXC46.1 < C49, C49, C), IIF(MAXC2.48 < C50 AND C50 > MAXC2.51, IIF(MAXC47.1 < C50, C50, C), IIF(MAXC2.49 < C51 AND C51 > MAXC2.52, IIF(MAXC48.1 < C51, C51, C), IIF(MAXC2.50 < C52 AND C52 > MAXC2.53, IIF(MAXC49.1 < C52, C52, C), IIF(MAXC2.51 < C53 AND C53 > MAXC2.54, IIF(MAXC50.1 < C53, C53, C), IIF(MAXC2.52 < C54 AND C54 > MAXC2.55, IIF(MAXC51.1 < C54, C54, C), IIF(MAXC2.53 < C55 AND C55 > MAXC2.56, IIF(MAXC52.1 < C55, C55, C), IIF(MAXC2.54 < C56 AND C56 > MAXC2.57, IIF(MAXC53.1 < C56, C56, C), IIF(MAXC2.55 < C57 AND C57 > MAXC2.58, IIF(MAXC54.1 < C57, C57, C), IIF(MAXC2.56 < C58 AND C58 > MAXC2.59, IIF(MAXC55.1 < C58, C58, C), IIF(MAXC2.57 < C59 AND C59 > MAXC2.60, IIF(MAXC56.1 < C59, C59, C), IIF(MAXC2.58 < C60 AND C60 > MAXC2.61, IIF(MAXC57.1 < C60, C60, C), IIF(MAXC2.59 < C61 AND C61 > MAXC2.62, IIF(MAXC58.1 < C61, C61, C), IIF(MAXC2.60 < C62 AND C62 > MAXC2.63, IIF(MAXC59.1 < C62, C62, C), IIF(MAXC2.61 < C63 AND C63 > MAXC2.64, IIF(MAXC60.1 < C63, C63, C), IIF(MAXC2.62 < C64 AND C64 > MAXC2.65, IIF(MAXC61.1 < C64, C64, C), IIF(MAXC2.63 < C65 AND C65 > MAXC2.66, IIF(MAXC62.1 < C65, C65, C), IIF(MAXC2.64 < C66 AND C66 > MAXC2.67, IIF(MAXC63.1 < C66, C66, C), IIF(MAXC2.65 < C67 AND C67 > MAXC2.68, IIF(MAXC64.1 < C67, C67, C), IIF(MAXC2.66 < C68 AND C68 > MAXC2.69, IIF(MAXC65.1 < C68, C68, C), IIF(MAXC2.67 < C69 AND C69 > MAXC2.70, IIF(MAXC66.1 < C69, C69, C), IIF(MAXC2.68 < C70 AND C70 > MAXC2.71, IIF(MAXC67.1 < C70, C70, C), IIF(MAXC2.69 < C71 AND C71 > MAXC2.72, IIF(MAXC68.1 < C71, C71, C), IIF(MAXC2.70 < C72 AND C72 > MAXC2.73, IIF(MAXC69.1 < C72, C72, C), IIF(MAXC2.71 < C73 AND C73 > MAXC2.74, IIF(MAXC70.1 < C73, C73, C), IIF(MAXC2.72 < C74 AND C74 > MAXC2.75, IIF(MAXC71.1 < C74, C74, C), IIF(MAXC2.73 < C75 AND C75 > MAXC2.76, IIF(MAXC72.1 < C75, C75, C), IIF(MAXC2.74 < C76 AND C76 > MAXC2.77, IIF(MAXC73.1 < C76, C76, C), IIF(MAXC2.75 < C77 AND C77 > MAXC2.78, IIF(MAXC74.1 < C77, C77, C), IIF(MAXC2.76 < C78 AND C78 > MAXC2.79, IIF(MAXC75.1 < C78, C78, C), IIF(MAXC2.77 < C79 AND C79 > MAXC2.80, IIF(MAXC76.1 < C79, C79, C), IIF(MAXC2.78 < C80 AND C80 > MAXC2.81, IIF(MAXC77.1 < C80, C80, C), IIF(MAXC2.79 < C81 AND C81 > MAXC2.82, IIF(MAXC78.1 < C81, C81, C), IIF(MAXC2.80 < C82 AND C82 > MAXC2.83, IIF(MAXC79.1 < C82, C82, C), IIF(MAXC2.81 < C83 AND C83 > MAXC2.84, IIF(MAXC80.1 < C83, C83, C), IIF(MAXC2.82 < C84 AND C84 > MAXC2.85, IIF(MAXC81.1 < C84, C84, C), IIF(MAXC2.83 < C85 AND C85 > MAXC2.86, IIF(MAXC82.1 < C85, C85, C), IIF(MAXC2.84 < C86 AND C86 > MAXC2.87, IIF(MAXC83.1 < C86, C86, C), IIF(MAXC2.85 < C87 AND C87 > MAXC2.88, IIF(MAXC84.1 < C87, C87, C), IIF(MAXC2.86 < C88 AND C88 > MAXC2.89, IIF(MAXC85.1 < C88, C88, C), IIF(MAXC2.87 < C89 AND C89 > MAXC2.90, IIF(MAXC86.1 < C89, C89, C), IIF(MAXC2.88 < C90 AND C90 > MAXC2.91, IIF(MAXC87.1 < C90, C90, C), IIF(MAXC2.89 < C91 AND C91 > MAXC2.92, IIF(MAXC88.1 < C91, C91, C), IIF(MAXC2.90 < C92 AND C92 > MAXC2.93, IIF(MAXC89.1 < C92, C92, C), IIF(MAXC2.91 < C93 AND C93 > MAXC2.94, IIF(MAXC90.1 < C93, C93, C), IIF(MAXC2.92 < C94 AND C94 > MAXC2.95, IIF(MAXC91.1 < C94, C94, C), IIF(MAXC2.93 < C95 AND C95 > MAXC2.96, IIF(MAXC92.1 < C95, C95, C), IIF(MAXC2.94 < C96 AND C96 > MAXC2.97, IIF(MAXC93.1 < C96, C96, C), IIF(MAXC2.95 < C97 AND C97 > MAXC2.98, IIF(MAXC94.1 < C97, C97, C), IIF(MAXC2.96 < C98 AND C98 > MAXC2.99, IIF(MAXC95.1 < C98, C98, C), IIF(MAXC2.97 < C99 AND C99 > MAXC2.100, IIF(MAXC96.1 < C99, C99, C), IIF(MAXC2.98 < C100 AND C100 > MAXC2.101, IIF(MAXC97.1 < C100, C100, C), IIF(MAXC2.99 < C101 AND C101 > MAXC2.102, IIF(MAXC98.1 < C101, C101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

And all instance of L in the second formula with C?

C < IIF(MINC2 > C2 AND C2 < MINC2.3, C, IIF(MINC2.1 > C3 AND C3 < MINC2.4, C3, IIF(MINC2.2 > C4 AND C4 < MINC2.5, IIF(C1 > C4, C4, C), IIF(MINC2.3 > C5 AND C5 < MINC2.6, IIF(MINC2.1 > C5, C5, C), IIF(MINC2.4 > C6 AND C6 < MINC2.7, IIF(MINC3.1 > C6, C6, C), IIF(MINC2.5 > C7 AND C7 < MINC2.8, IIF(MINC4.1 > C7, C7, C), IIF(MINC2.6 > C8 AND C8 < MINC2.9, IIF(MINC5.1 > C8, C8, C), IIF(MINC2.7 > C9 AND C9 < MINC2.10, IIF(MINC6.1 > C9, C9, C), IIF(MINC2.8 > C10 AND C10 < MINC2.11, IIF(MINC7.1 > C10, C10, C), IIF(MINC2.9 > C11 AND C11 < MINC2.12, IIF(MINC8.1 > C11, C11, C), IIF(MINC2.10 > C12 AND C12 < MINC2.13, IIF(MINC9.1 > C12, C12, C), IIF(MINC2.11 > C13 AND C13 < MINC2.14, IIF(MINC10.1 > C13, C13, C), IIF(MINC2.12 > C14 AND C14 < MINC2.15, IIF(MINC11.1 > C14, C14, C), IIF(MINC2.13 > C15 AND C15 < MINC2.16, IIF(MINC12.1 > C15, C15, C), IIF(MINC2.14 > C16 AND C16 < MINC2.17, IIF(MINC13.1 > C16, C16, C), IIF(MINC2.15 > C17 AND C17 < MINC2.18, IIF(MINC14.1 > C17, C17, C), IIF(MINC2.16 > C18 AND C18 < MINC2.19, IIF(MINC15.1 > C18, C18, C), IIF(MINC2.17 > C19 AND C19 < MINC2.20, IIF(MINC16.1 > C19, C19, C), IIF(MINC2.18 > C20 AND C20 < MINC2.21, IIF(MINC17.1 > C20, C20, C), IIF(MINC2.19 > C21 AND C21 < MINC2.22, IIF(MINC18.1 > C21, C21, C), IIF(MINC2.20 > C22 AND C22 < MINC2.23, IIF(MINC19.1 > C22, C22, C), IIF(MINC2.21 > C23 AND C23 < MINC2.24, IIF(MINC20.1 > C23, C23, C), IIF(MINC2.22 > C24 AND C24 < MINC2.25, IIF(MINC21.1 > C24, C24, C), IIF(MINC2.23 > C25 AND C25 < MINC2.26, IIF(MINC22.1 > C25, C25, C), IIF(MINC2.24 > C26 AND C26 < MINC2.27, IIF(MINC23.1 > C26, C26, C), IIF(MINC2.25 > C27 AND C27 < MINC2.28, IIF(MINC24.1 > C27, C27, C), IIF(MINC2.26 > C28 AND C28 < MINC2.29, IIF(MINC25.1 > C28, C28, C), IIF(MINC2.27 > C29 AND C29 < MINC2.30, IIF(MINC26.1 > C29, C29, C), IIF(MINC2.28 > C30 AND C30 < MINC2.31, IIF(MINC27.1 > C30, C30, C), IIF(MINC2.29 > C31 AND C31 < MINC2.32, IIF(MINC28.1 > C31, C31, C), IIF(MINC2.30 > C32 AND C32 < MINC2.33, IIF(MINC29.1 > C32, C32, C), IIF(MINC2.31 > C33 AND C33 < MINC2.34, IIF(MINC30.1 > C33, C33, C), IIF(MINC2.32 > C34 AND C34 < MINC2.35, IIF(MINC31.1 > C34, C34, C), IIF(MINC2.33 > C35 AND C35 < MINC2.36, IIF(MINC32.1 > C35, C35, C), IIF(MINC2.34 > C36 AND C36 < MINC2.37, IIF(MINC33.1 > C36, C36, C), IIF(MINC2.35 > C37 AND C37 < MINC2.38, IIF(MINC34.1 > C37, C37, C), IIF(MINC2.36 > C38 AND C38 < MINC2.39, IIF(MINC35.1 > C38, C38, C), IIF(MINC2.37 > C39 AND C39 < MINC2.40, IIF(MINC36.1 > C39, C39, C), IIF(MINC2.38 > C40 AND C40 < MINC2.41, IIF(MINC37.1 > C40, C40, C), IIF(MINC2.39 > C41 AND C41 < MINC2.42, IIF(MINC38.1 > C41, C41, C), IIF(MINC2.40 > C42 AND C42 < MINC2.43, IIF(MINC39.1 > C42, C42, C), IIF(MINC2.41 > C43 AND C43 < MINC2.44, IIF(MINC40.1 > C43, C43, C), IIF(MINC2.42 > C44 AND C44 < MINC2.45, IIF(MINC41.1 > C44, C44, C), IIF(MINC2.43 > C45 AND C45 < MINC2.46, IIF(MINC42.1 > C45, C45, C), IIF(MINC2.44 > C46 AND C46 < MINC2.47, IIF(MINC43.1 > C46, C46, C), IIF(MINC2.45 > C47 AND C47 < MINC2.48, IIF(MINC44.1 > C47, C47, C), IIF(MINC2.46 > C48 AND C48 < MINC2.49, IIF(MINC45.1 > C48, C48, C), IIF(MINC2.47 > C49 AND C49 < MINC2.50, IIF(MINC46.1 > C49, C49, C), IIF(MINC2.48 > C50 AND C50 < MINC2.51, IIF(MINC47.1 > C50, C50, C), IIF(MINC2.49 > C51 AND C51 < MINC2.52, IIF(MINC48.1 > C51, C51, C), IIF(MINC2.50 > C52 AND C52 < MINC2.53, IIF(MINC49.1 > C52, C52, C), IIF(MINC2.51 > C53 AND C53 < MINC2.54, IIF(MINC50.1 > C53, C53, C), IIF(MINC2.52 > C54 AND C54 < MINC2.55, IIF(MINC51.1 > C54, C54, C), IIF(MINC2.53 > C55 AND C55 < MINC2.56, IIF(MINC52.1 > C55, C55, C), IIF(MINC2.54 > C56 AND C56 < MINC2.57, IIF(MINC53.1 > C56, C56, C), IIF(MINC2.55 > C57 AND C57 < MINC2.58, IIF(MINC54.1 > C57, C57, C), IIF(MINC2.56 > C58 AND C58 < MINC2.59, IIF(MINC55.1 > C58, C58, C), IIF(MINC2.57 > C59 AND C59 < MINC2.60, IIF(MINC56.1 > C59, C59, C), IIF(MINC2.58 > C60 AND C60 < MINC2.61, IIF(MINC57.1 > C60, C60, C), IIF(MINC2.59 > C61 AND C61 < MINC2.62, IIF(MINC58.1 > C61, C61, C), IIF(MINC2.60 > C62 AND C62 < MINC2.63, IIF(MINC59.1 > C62, C62, C), IIF(MINC2.61 > C63 AND C63 < MINC2.64, IIF(MINC60.1 > C63, C63, C), IIF(MINC2.62 > C64 AND C64 < MINC2.65, IIF(MINC61.1 > C64, C64, C), IIF(MINC2.63 > C65 AND C65 < MINC2.66, IIF(MINC62.1 > C65, C65, C), IIF(MINC2.64 > C66 AND C66 < MINC2.67, IIF(MINC63.1 > C66, C66, C), IIF(MINC2.65 > C67 AND C67 < MINC2.68, IIF(MINC64.1 > C67, C67, C), IIF(MINC2.66 > C68 AND C68 < MINC2.69, IIF(MINC65.1 > C68, C68, C), IIF(MINC2.67 > C69 AND C69 < MINC2.70, IIF(MINC66.1 > C69, C69, C), IIF(MINC2.68 > C70 AND C70 < MINC2.71, IIF(MINC67.1 > C70, C70, C), IIF(MINC2.69 > C71 AND C71 < MINC2.72, IIF(MINC68.1 > C71, C71, C), IIF(MINC2.70 > C72 AND C72 < MINC2.73, IIF(MINC69.1 > C72, C72, C), IIF(MINC2.71 > C73 AND C73 < MINC2.74, IIF(MINC70.1 > C73, C73, C), IIF(MINC2.72 > C74 AND C74 < MINC2.75, IIF(MINC71.1 > C74, C74, C), IIF(MINC2.73 > C75 AND C75 < MINC2.76, IIF(MINC72.1 > C75, C75, C), IIF(MINC2.74 > C76 AND C76 < MINC2.77, IIF(MINC73.1 > C76, C76, C), IIF(MINC2.75 > C77 AND C77 < MINC2.78, IIF(MINC74.1 > C77, C77, C), IIF(MINC2.76 > C78 AND C78 < MINC2.79, IIF(MINC75.1 > C78, C78, C), IIF(MINC2.77 > C79 AND C79 < MINC2.80, IIF(MINC76.1 > C79, C79, C), IIF(MINC2.78 > C80 AND C80 < MINC2.81, IIF(MINC77.1 > C80, C80, C), IIF(MINC2.79 > C81 AND C81 < MINC2.82, IIF(MINC78.1 > C81, C81, C), IIF(MINC2.80 > C82 AND C82 < MINC2.83, IIF(MINC79.1 > C82, C82, C), IIF(MINC2.81 > C83 AND C83 < MINC2.84, IIF(MINC80.1 > C83, C83, C), IIF(MINC2.82 > C84 AND C84 < MINC2.85, IIF(MINC81.1 > C84, C84, C), IIF(MINC2.83 > C85 AND C85 < MINC2.86, IIF(MINC82.1 > C85, C85, C), IIF(MINC2.84 > C86 AND C86 < MINC2.87, IIF(MINC83.1 > C86, C86, C), IIF(MINC2.85 > C87 AND C87 < MINC2.88, IIF(MINC84.1 > C87, C87, C), IIF(MINC2.86 > C88 AND C88 < MINC2.89, IIF(MINC85.1 > C88, C88, C), IIF(MINC2.87 > C89 AND C89 < MINC2.90, IIF(MINC86.1 > C89, C89, C), IIF(MINC2.88 > C90 AND C90 < MINC2.91, IIF(MINC87.1 > C90, C90, C), IIF(MINC2.89 > C91 AND C91 < MINC2.92, IIF(MINC88.1 > C91, C91, C), IIF(MINC2.90 > C92 AND C92 < MINC2.93, IIF(MINC89.1 > C92, C92, C), IIF(MINC2.91 > C93 AND C93 < MINC2.94, IIF(MINC90.1 > C93, C93, C), IIF(MINC2.92 > C94 AND C94 < MINC2.95, IIF(MINC91.1 > C94, C94, C), IIF(MINC2.93 > C95 AND C95 < MINC2.96, IIF(MINC92.1 > C95, C95, C), IIF(MINC2.94 > C96 AND C96 < MINC2.97, IIF(MINC93.1 > C96, C96, C), IIF(MINC2.95 > C97 AND C97 < MINC2.98, IIF(MINC94.1 > C97, C97, C), IIF(MINC2.96 > C98 AND C98 < MINC2.99, IIF(MINC95.1 > C98, C98, C), IIF(MINC2.97 > C99 AND C99 < MINC2.100, IIF(MINC96.1 > C99, C99, C), IIF(MINC2.98 > C100 AND C100 < MINC2.101, IIF(MINC97.1 > C100, C100, C), IIF(MINC2.99 > C101 AND C101 < MINC2.102, IIF(MINC98.1 > C101, C101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Monday, September 10, 2018 5:45:48 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce that was easy :) thank you that works 

Cheers
Back to top
Bruce_L
Posted : Monday, September 10, 2018 5:54:45 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.