C
Corey
Why does this function not work?
=IF(39752>=Sheet2!D3>=39722,Sheet2!A3,0)
=IF(39752>=Sheet2!D3>=39722,Sheet2!A3,0)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
S
Sean Timmons
you should use an AND instead.
=IF(AND(39752>=Sheet2!D3,Sheet2!D3>=39722),Sheet2!A3,0)
=IF(AND(39752>=Sheet2!D3,Sheet2!D3>=39722),Sheet2!A3,0)
M
Max
Why does this function not work?
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
---
=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
---
D
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)
=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)
C
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.
certain range. for example, i want to dis play A3 when B3 is greater than 4
and less than 8.