Combining IF function with OR function

[Need_Excel_Help]

I need a function that will look at a cell and give me a 1 if it is between 2 numbers and a 0 if it is not, and if the sum of the numbers I am looking at <10 then to put a 1 in the cell.
Below is the first part of the question; what I need to do now is say if a sum of range of cells is <10, override the first part of the function and automatically place a 1 in the cell. I think I can use the OR function for this, I just can't figure out how to.

=IF(I99<0.8,0,IF(I99>1.2,0,1))

[jeffreybrown]

Hello & Welcome to the Board,

Not sure what cells you want to sum, but something like this would work for looking at I99 and then the sum of I95:I98.

=IF(AND(OR(I99<0.8,I99>1.2),SUM(I95:I98)<10),0,1)