Hey Bruce 

hope you doing well could you please help me in changing the below pcf to a 13 bar from 5 bar pcf , I use H13 * ABS(MAXH13 < H13 AND H13 > MAXH13.14)  and if you can please give a template to change the numbers from 13 to 21, 34 or 55 

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 one for low where changing to 13 bar from 5 bar pcf and i use L13 * ABS(MINL13 > L13 AND L13 < MINL13.14) and if you can please give a template to change the numbers from 13 to 21, 34 or 55 

I am going to start with the "template" and then provide a formula for the 13 bar version. Keep in mind that there really isn't a way to do this where you could could just plug the entire thing into a text editor and use the replace function.

Note that I am going to assume that you are actually converting a 2 bar version to a 13 bar version in order to make the nomenclature match. The other way to do this would be to assume you wanted to convert a 5 bar version to a 27 bar version. Neither description is really any better than the other, but you would need to use those values if you want the names to be consistent with each other.

For the first term we only need to check if the high (or low) was detected on the most recent bar. If it was , the entire formula is going to be false (so we will return C since C cannot be etiher > or < than C and we use this trick throughout the rest of the formula).

IIF(MAXHp < Hp AND Hp > MAXHp.r, C, insert formula for second terrm here)

The second term can return true or false (so we return the value of the central high or low), but we don't need to check if this has been true previous since the high or low was detected. This is because it was detected on the previous bar, so there are no intervening bars.

IIF(MAXHp.1 < Hq AND Hq > MAXHp.r, Hq, insert formula for third term here)

All of the rest of the terms used the same structure (although in the third term you can simplify MAXC1.x or MINC1.x to just Cx). The first two terms actually use this basic structure as well, but can leave parts out since they aren't applicable or simplify out of the formula.

IIF(MAXHp.u < Hq AND Hq > MAXHp.r, IIF(MAXCs.1 < Hq, Hq, C), insert formula for next term here)

You take this out to as many terms as necessary (within the limits of the available data and without making it too long and slow to be practical).

Then you put a C > in front of the entire thing and substitute C for insert formula for next term here in the last term (since there is no next term to insert and you need the entire formula to return false as a result).

To invert the formula and check for lows instead of highs, replace H with L, MAX with MIN and reverse of the > and < signs in the formula (this step can be done using the replace function in a text editor, although you might have to replace twice to get the > and < signs reversed using in intermediate symbol).

So the 13 period high formula would be the following.

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

And the 13 period low formula would be the following.

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

Awesome Bruce that works perfect... 

thanks a lot for template as well 

Cheers

You're welcome.