what is the best practice of using formulas on this senario so that workbook does not become slow.

[President]

i have workbook that i received from my sister, it has alot of formulas with hardcoded text in them.

for example =if(A2="Procurement Department Los Angeles Area", True, False) would it make any different in terms of speed if i put text Procurement Department Los Angeles Area in a cell lets say B1 and i simply =if(A2=B$1, True, False)

 

[Oeldere]

I don't think it will increase the speed by putting this in another cell.

I will think it will make it easier to amend if you want to copy the formula.

 

[Dave Patton]

You probably do not need the "if"

Either of the following will work.

Excel 2010
	A	B	C	D
1		Procurement Department Los Angeles Area
2	Procurement Department Los Angeles Area	TRUE
3	Procurement Department Los Angeles Area	TRUE
4
1a

Cell Formulas
Range	Formula
B2	=A2="Procurement Department Los Angeles Area"
B3	=A3=B1

Named Ranges
Name	Refers To	Cells
rT	=zList!$B$2:$D$3

 

[President]

thanks very much both.