another way would be to tell us what your formula actually looks like\
generally if(a1=1,a2*2,a2),ie if condtion is true multiply a2x2 if false a2
is ummm a2
--
paul

remove nospam for email addy!



"Carim" wrote:


Hi,

Try surround your formula with :
=IF(ISERROR(yourformula),"",yourformula)

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531769