Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function help
Why does this function not work?
=IF(39752=Sheet2!D3=39722,Sheet2!A3,0) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |