# Formula help for newbie

#### spotforex

##### New Member
Hi Everyone

I'm new to this forum and would like to request some help from the experts.

I've imported daily high-low price data that was run through a TradeStation indicator(columns B & C) and am trying to create a frequency distribution spreadsheet.

If we look at cell D3, as an example, I would like a result of 1 if the Value High-Low range has traded at any time above the Value of 8, otherwise return a result of 0. I believe I've coded the formula correctly for columns D to G and P to S with the appropriate numerical adjustments but I am not especially confident. Could someone please check to see if my logic is correct.

My main problem is creating an appropriate formula for the remaining columns, H through O. Looking at column O, if the Value High-Low range has traded at any time between the values of -1 to 1 then return a value of 1, otherwise a value of 0. I have made several attempts, as you can see from the formulas, but I get results, through visual inspection, that are clearly incorrect. Any suggestions or guidance would be greatly appreciated.

John

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=20><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - CAD_daily_98_02.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2000 : OS = Windows 98 </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=20><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb605117><INPUT onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' type=button value="Copy Formula" name=btCb942116></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=20><TABLE border=0><TBODY><TR><FORM name=formFb202339><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name=sltNb447362><OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))" selected>D2<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E2<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F2<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G2<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H2<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I2<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J2<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K2<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L2<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M2<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N2<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O2<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P2<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q2<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R2<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S2<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D3<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E3<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F3<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G3<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H3<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I3<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J3<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K3<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L3<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M3<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N3<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O3<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P3<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q3<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R3<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S3<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D4<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E4<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F4<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G4<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H4<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I4<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J4<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K4<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L4<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M4<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N4<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O4<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P4<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q4<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R4<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S4<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D5<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E5<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F5<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G5<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H5<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I5<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J5<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K5<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L5<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M5<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N5<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O5<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P5<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q5<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R5<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S5<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D6<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E6<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F6<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G6<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H6<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I6<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J6<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K6<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L6<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M6<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N6<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O6<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P6<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q6<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R6<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S6<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D7<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E7<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F7<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G7<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H7<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I7<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J7<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K7<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L7<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M7<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N7<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O7<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P7<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q7<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R7<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S7<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D8<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E8<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F8<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G8<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H8<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I8<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J8<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K8<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L8<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M8<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N8<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O8<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P8<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q8<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R8<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S8<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D9<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E9<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F9<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G9<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H9<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I9<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J9<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K9<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L9<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M9<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N9<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O9<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P9<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q9<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R9<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S9<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D10<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E10<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F10<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G10<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H10<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I10<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J10<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K10<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L10<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M10<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N10<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O10<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P10<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q10<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R10<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S10<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D11<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E11<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F11<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G11<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H11<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I11<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J11<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K11<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L11<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M11<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N11<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O11<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P11<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q11<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R11<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S11<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D12<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E12<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F12<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G12<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H12<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I12<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J12<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K12<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L12<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M12<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N12<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O12<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P12<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q12<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R12<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S12<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D13<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E13<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F13<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G13<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H13<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I13<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J13<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K13<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L13<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M13<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N13<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O13<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P13<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q13<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R13<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S13<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D14<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E14<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F14<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G14<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H14<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I14<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J14<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K14<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L14<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M14<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N14<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O14<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P14<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q14<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R14<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S14<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D15<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E15<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F15<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G15<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H15<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I15<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J15<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K15<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L15<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M15<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N15<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O15<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P15<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q15<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R15<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S15<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D16<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E16<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F16<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G16<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H16<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I16<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J16<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K16<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L16<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M16<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N16<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O16<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P16<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q16<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R16<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S16<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D17<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E17<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F17<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G17<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H17<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I17<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J17<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K17<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L17<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M17<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N17<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O17<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P17<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q17<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R17<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S17<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D18<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E18<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F18<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G18<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H18<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I18<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J18<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K18<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L18<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M18<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N18<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O18<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P18<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q18<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R18<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S18<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D19<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E19<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F19<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G19<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H19<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I19<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J19<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K19<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L19<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M19<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N19<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O19<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P19<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q19<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R19<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S19<OPTION value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))">D20<OPTION value="=IF(Value_Low>7,1,IF(Value_High>7,1,0))">E20<OPTION value="=IF(Value_Low>6,1,IF(Value_High>6,1,0))">F20<OPTION value="=IF(Value_Low>5,1,IF(Value_High>5,1,0))">G20<OPTION value="=IF(Value_Low<8 & Value_Low>-8,1,IF(Value_High<8 & Value_High>-8,1,0))">H20<OPTION value="=IF(Value_Low<7 & Value_Low>-7,1,IF(Value_High<7 & Value_High>-7,1,0))">I20<OPTION value="=IF(Value_Low<6 & Value_Low>-6,1,IF(Value_High<6 & Value_High>-6,1,0))">J20<OPTION value="=IF(Value_Low<5 & Value_Low>-5,1,IF(Value_High<5 & Value_High>-5,1,0))">K20<OPTION value="=IF(Value_Low<4 & Value_Low>-4,1,IF(Value_High<4 & Value_High>-4,1,0))">L20<OPTION value="=IF(Value_Low<3 & Value_Low>-3,1,IF(Value_High<3 & Value_High>-3,1,0))">M20<OPTION value="=IF(Value_Low<2 & Value_Low>-2,1,IF(Value_High<2 & Value_High>-2,1,0))">N20<OPTION value="=IF(AND(1<=Value_High,OR(-1>=Value_Low,-1<=Value_Low)),1,IF(AND(1>=Value_High,OR(-1>Value_Low,-1<Value_Low)),1,0))">O20<OPTION value="=IF(Value_High<-5,1,IF(Value_Low<-5,1,0))">P20<OPTION value="=IF(Value_High<-6,1,IF(Value_Low<-6,1,0))">Q20<OPTION value="=IF(Value_High<-7,1,IF(Value_Low<-7,1,0))">R20<OPTION value="=IF(Value_High<-8,1,IF(Value_Low<-8,1,0))">S20</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value="=IF(Value_Low>8,1,IF(Value_High>8,1,0))" name=txbFb150492></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Replies
0
Views
266
Replies
1
Views
179
Replies
2
Views
408
Replies
1
Views
231
Replies
10
Views
778

1,195,691
Messages
6,011,166
Members
441,590
Latest member
kukaljcanin

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back