Hi I have a really long if formula and excel limits the number of if
formulas you can use in any one cell. So if someone would help me out
and show me how to convert this into VBA then I could add in the rest
of the formulas my self.

=IF(COUNTIF(A121,"*18-00 Seven News SEVEN
Brisbane*")*1,200,IF(COUNTIF(A121,"*18-00 Seven News SEVEN
Sydney*")*1,300,0))

Thanks.


--
Vlad999
------------------------------------------------------------------------
Vlad999's Profile: http://www.excelforum.com/member.php...o&userid=33586
View this thread: http://www.excelforum.com/showthread...hreadid=544111