-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
EXCEL CALCULATIONS: what order does it happen, left, right
- Thread starter itr674
- Start date
Pascalvrolijk
Board Regular
- Joined
- May 28, 2004
- Messages
- 68
Re: EXCEL CALCULATIONS: what order does it happen, left, ri
an example would clearify your question. Excel does a formula exactly as you type it..
an example would clearify your question. Excel does a formula exactly as you type it..
Upvote
0
Re: EXCEL CALCULATIONS: what order does it happen, left, ri
I wasn't so much talking about the formula in the cell but the sheet as a whole. I am using these two formulas to get the date from a very large sheet to a small sheet.
The second formula looks at a sheet and return the row numbe for a particular column and the first fomula then looks at that row number and column for the date. So basically the first formula only looks in one place where the second formula is searching the entire range...
=IF(ISNUMBER(AQ17),INDEX(NextDue,AQ17),"")
=MATCH(M$13&CHAR(127)&$G17,ConCat,0)
I wasn't so much talking about the formula in the cell but the sheet as a whole. I am using these two formulas to get the date from a very large sheet to a small sheet.
The second formula looks at a sheet and return the row numbe for a particular column and the first fomula then looks at that row number and column for the date. So basically the first formula only looks in one place where the second formula is searching the entire range...
=IF(ISNUMBER(AQ17),INDEX(NextDue,AQ17),"")
=MATCH(M$13&CHAR(127)&$G17,ConCat,0)
Upvote
0
jimbojones
Well-known Member
- Joined
- Apr 22, 2002
- Messages
- 776
Re: EXCEL CALCULATIONS: what order does it happen, left, ri
I think the excel calculation algorithm is pretty complicated...mainly dependent on prececedence. But in general assuming all formulas are equal in priority I *believe* it calculates down each column.
Why should this matter?
In your example Excel should prioritise the formulas in the order which the results are needed. i.e. in your example excel should calculate the second formula first as the first formula is dependant upon this result.
Hmmm.
James
I think the excel calculation algorithm is pretty complicated...mainly dependent on prececedence. But in general assuming all formulas are equal in priority I *believe* it calculates down each column.
Why should this matter?
In your example Excel should prioritise the formulas in the order which the results are needed. i.e. in your example excel should calculate the second formula first as the first formula is dependant upon this result.
Hmmm.
James
Upvote
0
tusharm
MrExcel MVP
- Joined
- May 28, 2002
- Messages
- 11,029
Re: EXCEL CALCULATIONS: what order does it happen, left, ri
For some authoritative information -- or as authoritative as one can hope to get -- see
Recalculation in Microsoft Excel 2002
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlrecalc.asp
How Formula Calculations Are Performed in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;825012
It never hurts to search support.microsoft.com and msdn.microsoft.com
For some authoritative information -- or as authoritative as one can hope to get -- see
Recalculation in Microsoft Excel 2002
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlrecalc.asp
How Formula Calculations Are Performed in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;825012
It never hurts to search support.microsoft.com and msdn.microsoft.com
Upvote
0
Similar threads
- Question
