Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function within a function
hi my function is Code: -------------------- =IF(MONTH(TODAY())=(MONTH($H$4)),H6,) -------------------- . if i were to add a function in the false statement, it will only allow this 6 or 7 times. is there a way to get around this using functions? eg. Code: -------------------- =IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6, IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6IF (MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6IF(M ONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6) -------------------- thanks -- jay d ------------------------------------------------------------------------ jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487 View this thread: http://www.excelforum.com/showthread...hreadid=553261 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function within a function
Jay You are only allowed 7 nested functions but if you post your data and what you want to do with it (your OP has the same IF over and over) it would be easier to help. Regards, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=553261 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function within a function
I am assuming the data you want returned is in row 6 (beginning in column H),
the dates are in row 4 (beginning in column H). As mentioned, your example simply repeats the same range references, which is not helpful. =INDEX(trends!H6:L6,MATCH(MONTH(TODAY()),MONTH(tre nds!H4:L4),0)) must use Control+Shift+Enter after typing in the formula, change ranges as needed. "jay d" wrote: hi my function is Code: -------------------- =IF(MONTH(TODAY())=(MONTH($H$4)),H6,) -------------------- . if i were to add a function in the false statement, it will only allow this 6 or 7 times. is there a way to get around this using functions? eg. Code: -------------------- =IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6, IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6IF (MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6IF(M ONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6) -------------------- thanks -- jay d ------------------------------------------------------------------------ jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487 View this thread: http://www.excelforum.com/showthread...hreadid=553261 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function within a function
hi i want to have this Code: -------------------- =IF(MONTH(TODAY())=(MONTH(Trends!$f$4)),Trends!f6, IF(MONTH(TODAY())=(MONTH(Trends!$g$4)),Trends!g6, IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6, IF(MONTH(TODAY())=(MONTH(Trends!$i$4)),Trends!i6, IF(MONTH(TODAY())=(MONTH(Trends!$j$4)),Trends!j6, IF(MONTH(TODAY())=(MONTH(Trends!$k$4)),Trends!k6, IF(MONTH(TODAY())=(MONTH(Trends!$l$4)),Trends!l6,I F(MONTH(TODAY())=(MONTH(Trends!$m$4)),Trends!m6, IF(MONTH(TODAY())=(MONTH(Trends!$n$4)),Trends!n6, IF(MONTH(TODAY())=(MONTH(Trends!$o$4)),Trends!o6,) -------------------- but its more than 7 functions... thanks -- jay d ------------------------------------------------------------------------ jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487 View this thread: http://www.excelforum.com/showthread...hreadid=553261 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function within a function
You should be able to adjust the ranges as follows:
=INDEX(trends!F6:06,MATCH(MONTH(TODAY()),MONTH(tre nds!F4:O4),0)) Again, it is an array formula, so you will need to hit Control+Shift+Enter when you key it in, not just the Enter key. If you do it right, Excel will put braces { } around the formula. "jay d" wrote: hi i want to have this Code: -------------------- =IF(MONTH(TODAY())=(MONTH(Trends!$f$4)),Trends!f6, IF(MONTH(TODAY())=(MONTH(Trends!$g$4)),Trends!g6, IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6, IF(MONTH(TODAY())=(MONTH(Trends!$i$4)),Trends!i6, IF(MONTH(TODAY())=(MONTH(Trends!$j$4)),Trends!j6, IF(MONTH(TODAY())=(MONTH(Trends!$k$4)),Trends!k6, IF(MONTH(TODAY())=(MONTH(Trends!$l$4)),Trends!l6,I F(MONTH(TODAY())=(MONTH(Trends!$m$4)),Trends!m6, IF(MONTH(TODAY())=(MONTH(Trends!$n$4)),Trends!n6, IF(MONTH(TODAY())=(MONTH(Trends!$o$4)),Trends!o6,) -------------------- but its more than 7 functions... thanks -- jay d ------------------------------------------------------------------------ jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487 View this thread: http://www.excelforum.com/showthread...hreadid=553261 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function within a function
cheers for that, didnt know you could do that in excel -- jay d ------------------------------------------------------------------------ jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487 View this thread: http://www.excelforum.com/showthread...hreadid=553261 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |