tonywatsonhelp
Wellknown Member
 Joined
 Feb 24, 2014
 Messages
 2,719
 Office Version

 365
 2019
 2016
 Platform

 Windows
Hi Everyone,
(if I'm saying function but should say formula please understand i mean the "choose"eg. "=Choose(A1,1,2,3,4,5,6) )
I was recently helped with a problem and the solution used the choose function.
on investigating it seams this is a very useful function and one i could find many many uses for.
My worry is i don't know how much resources the function uses so i don't know if I'm better off continuing to use my current style most of the time or move over to the choose function that would be very helpful and easier to set up.
So my question is does anyone know if Choose is classed as a light function or heavy function?
If that terminology is not a familiar one let me try explain
as I understand it formulas like "Sum", "If", "Sumifs" etc are quite light, you can use then hundreds of times even thousands of time in a document with little effect on the speed of the document.
I know this to be true as i use them all day every day,
however I have also found some formulas just clog up the document if you use them too often, like Array formulas, Indirect, etc. so whilst they are useful, i tend to try avoid then in areas where im repeating the formula down a column for example.
so my question is does anyone know if choose is relatively light or heavy? should i avoid it if the formula is for every cell in a column of 1000rows for example?
I know this might not be an exact answer, i understand excel and formulas quite well but before i go build a new document for myself and end up having to redo it because the choose function is clogging everything up i just thought id ask if anyone knows?
Thanks
Tony
(if I'm saying function but should say formula please understand i mean the "choose"eg. "=Choose(A1,1,2,3,4,5,6) )
I was recently helped with a problem and the solution used the choose function.
on investigating it seams this is a very useful function and one i could find many many uses for.
My worry is i don't know how much resources the function uses so i don't know if I'm better off continuing to use my current style most of the time or move over to the choose function that would be very helpful and easier to set up.
So my question is does anyone know if Choose is classed as a light function or heavy function?
If that terminology is not a familiar one let me try explain
as I understand it formulas like "Sum", "If", "Sumifs" etc are quite light, you can use then hundreds of times even thousands of time in a document with little effect on the speed of the document.
I know this to be true as i use them all day every day,
however I have also found some formulas just clog up the document if you use them too often, like Array formulas, Indirect, etc. so whilst they are useful, i tend to try avoid then in areas where im repeating the formula down a column for example.
so my question is does anyone know if choose is relatively light or heavy? should i avoid it if the formula is for every cell in a column of 1000rows for example?
I know this might not be an exact answer, i understand excel and formulas quite well but before i go build a new document for myself and end up having to redo it because the choose function is clogging everything up i just thought id ask if anyone knows?
Thanks
Tony