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

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

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

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

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

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