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))