Excel function help
 

Why does this function not work?

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

Excel function help
 

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

"Corey" wrote:

Why does this function not work?

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

Excel function help
 

you should use an AND instead.

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

"Corey" wrote:

Why does this function not work?

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

Excel function help
 

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

Excel function help
 

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 wrote:

Why does this function not work?

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

--

Dave Peterson

Excel function help
 

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.

"Mike H" wrote:

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

"Corey" wrote:

Why does this function not work?

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

Excel function help
 

=IF(AND(39752=Sheet2!D3,Sheet2!D3=39722),Sheet2! A3,0)
--
David Biddulph

"Corey" wrote in message
...
Why does this function not work?

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