Excel function help

[Corey]

Why does this function not work?

=IF(39752>=Sheet2!D3>=39722,Sheet2!A3,0)

 

[Mike H]

Corey,

Perhaps you could express in words what your trying to do because this bit
of your formula doesn't really make sense.

=IF(39752>=Sheet2!D3>=39722

Mike

 

[Sean Timmons]

you should use an AND instead.

=IF(AND(39752>=Sheet2!D3,Sheet2!D3>=39722),Sheet2!A3,0)

 

[Max]

Why does this function not work?

=IF(39752>=Sheet2!D3>=39722,Sheet2!A3,0)

You need to use an AND, eg:
=IF(and(Sheet2!D3>=39722,Sheet2!D3<=39752),Sheet2!A3,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,500 Files:361 Subscribers:58
xdemechanik
---

 

[Dave Peterson]

You'd want to use =and():

=if(and(sheet2!d3>=39722,sheet2!d3<=39752),sheet2!a3,0)

If those numbers are really dates, I'd use:
=if(and(sheet2!d3>=date(2008,10,1),sheet2!d3<=date(2008,10,31))sheet2!a3,0)

or even:
=if(text(sheet2!d3,"yyyymm")="200810",sheet2!a3,0)

 

[Corey]

I want to display a cell on row 3 when a second cell in row 3 is within a
certain range. for example, i want to dis play A3 when B3 is greater than 4
and less than 8.

 

[David Biddulph]

=IF(AND(39752>=Sheet2!D3,Sheet2!D3>=39722),Sheet2!A3,0)