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