Making workbook lighter / optimizing

[Beneindias]

Hi everybody.

I'm trying to make my workbook lighter to calculate, but I have a question.

Is lighter to use a named formula a few times in the same row, or should I use helper columns and compare the result in the other cells?

For example 1: Using named formula in all cells "XYZ" that it's like that:
"XYZ"=IF(OR(AND(A1=10;A2=11);AND(A1=5;A2=51)))

Cell O:
=If(XYZ;"Yes")

Cell K:
=If(XYZ;4+5)

For example 2: Using an helper cell:
"XYZ"=IF(OR(AND(A1=10;A2=11);AND(A1=5;A2=51)))

Cell I (helper cell):
=XYZ

Cell O:
=IF(I=TRUE;"Yes")

Cell K:
=IF(I=TRUE;4+5)

Which one would be lighter to recalculate?

I know this to simple, but I'm trying to do this in cells and formulas with a lot of logic and sometimes more than 10 parameters.

Can you help me with this?


Thank you all

 

[dfsobral]

test it

use this macro

Sub testSpeed()

Dim star As Double
Dim time As Double

star = Timer
Application.Calculate
time = Timer - star

MsgBox "Calculated in " & time & "seconds"

End Sub

 

[Beneindias]

test it

use this macro

Sub testSpeed()

Dim star As Double
Dim time As Double

star = Timer
Application.Calculate
time = Timer - star

MsgBox "Calculated in " & time & "seconds"

End Sub

Thanks.

Will try that