Formula? Or Macro? Which is faster?

I have a problem in that i perform lots of analysis using formula. In an attempt to speed the sheet up i have copied these formula to a control sheet from which i re put them into my master sheet and then replace as values. The problem is that this workbook is rather huge and has become very slow rather quickly.

Example formula are ;listed below. I was wondering what would be the most robust method of performing this analysis. Via macro? or a different way of writing my formula?

e.g.

=IF(AND(ISNUMBER(TC9),(ISNUMBER(TD9))),(TD9-TC9),(""))

=IF(AND(ISNUMBER($R22),(ISNUMBER($AI22))),($AI22),IF(ISNUMBER($R22),(0),("")))

=IF(AND(ISNUMBER(R9),(RA9>=100)),($RH$27),IF(AND(ISNUMBER(R9),(ISNUMBER(RA9))),($RL$31*(EXP($RK$31*RA9))),("")))


Any comments,/help/examples would be appreciated.

Alan

i have loads of similar formula, all referencing each other. There is simply alot of them, i cannot provide example sheet data is confidential. :s

?

Your formulae also have some unnecessary parenthesis

fi (T9-C9), ("") etc...

Don't think that slows things down though

Also, do you have any volatile functions in your wbooks? ( TODAY, NOW, INDIRECT, etc...) ?

Domski, thanks for the tip. I have been trying to figure that one out for a while now.