simple Question

[Guest]

hi

this is my formula:
=IF(D25=0,0,IF(D26=0,0,A26))

problem:
active cell should equal 0, if D25's value is not between 0 and 7
(the same for the D26 reference)

how would i do this?
tia

 

[JE McGimpsey]

One way:

=IF(AND(D25>0,D25<7),IF(AND(D25>0,D26<0),A26,0),0)


another:

=IF(COUNTIF(D2526,">0")+COUNTIF(D2526,"<7")=4,A26,0)

another:

=IF(OR(D25<0,D26<0,D25>7,D26>7),0,A26)