ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Re-calc. speed question (https://www.excelbanter.com/excel-worksheet-functions/21013-re-calc-speed-question.html)

GerryK

Re-calc. speed question
 

Would somebody happen to know if Excel 2003 takes more
time to do this function:
=IF(ISBLANK('Form B'!D2),"",'Form B'!D2)

as opposed to =('Form B'!D2)conditionally formated to
white with format condition; cell value =0 as would be
case if the target cell was blank.

The reason is that a workbook with a lot of formulas and a
lot of tabs using the first case senario, is taking a long
time to recalculate. I normally use the second senario in
my work. I coud chang I but ned to now if my time spnt
would be of ay vaue!

TIA



All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com