hi

my function is 
=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. 
=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(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6)
thanks