Help with IF(OR(AND Formula

[brianjluke]

Hi,

I'm looking for guidance on changing a formula to incorporate additional cells. I inherited this file and I'm unfamiliar with this formula: =IF(OR(AND(H$2>=$C3,H$2<$D3),AND(H$2<$F3,H$2>=$E3,H$2>=$C3)),1,0)

If I now have two new columns (D & G) how do I include these colums in this formula with the same values in the formula (1 and 0)?

Any help you could provide this novice would be greatly appreciated.! I'm attaching a working example to this post.IF-OR-AND Example.xlsx

[RobertMika]

You need another value here:
=IF(OR(AND(H$2>=$C3,H$2<$D3),AND(H$2<$F3,H$2>=$E3,H$2>=$C3),AND(.....)),1,0)
Put your statments in the ... posistion.D2>G3 or anything which is logical test...