combine "if" with "and" function

[Erik]

I'm trying to creat a formula that will do the following:

if(A1>B1 and A1<C1 than D1 if not than 0

I don't know how to incorporate the two functions to get
the result from D1. The only result I can get it to
display is either true or 0 (False). This would be fine
if I were only using one if function, but I need to nest 7
if funtions in one cell.
Can anyone help?

Thanks,

Erik

 

[Frank Kabel]

Hi
=IF(AND(A1>B1,A1<C1),D1,0)

 

[Dave R.]

=IF(AND(A1>B1,A1<C1),D1,0)

you're at the limit for nesting if you want to go 7, if you want another way
you can post back with more info for alternate solution(s).

 

[JE McGimpsey]

One way:

=IF(AND(A1>B1,A1<C1),D1,0)

or, equivalently:

=(A1>B1)*(A1<C1)*D1

 

[Peo Sjoblom]

=If(AND(A1>B1,A1<C1),D1,0)

 

[Erik]

Thanks for all the help, that's exactly what I needed...

Erik