simple Question

M

Mo2

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
 
J

JE McGimpsey

One way:

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


another:

=IF(COUNTIF(D25:D26,">0")+COUNTIF(D25:D26,"<7")=4,A26,0)

another:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top