| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does this slow down calculation?
I want to put some spaces between arguments in formulas to make the more
readable but I was wondering if this slows down the calculation time? For example if I have a sheet with many formulas will the calculation times be different between the two examples? IF(VLOOKUP(A1,MyRange,3,False)="yes",Sum(D1:G1),av erage(B1:C1)) IF( VLOOKUP(A1,MyRange,3,False)="yes", Sum(D1:G1), Average(B1:C1)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Does this slow down calculation?
I don't think so.
In fact, I sometimes add alt-enters to make the formula easier to read, too. sfrancoe wrote: I want to put some spaces between arguments in formulas to make the more readable but I was wondering if this slows down the calculation time? For example if I have a sheet with many formulas will the calculation times be different between the two examples? IF(VLOOKUP(A1,MyRange,3,False)="yes",Sum(D1:G1),av erage(B1:C1)) IF( VLOOKUP(A1,MyRange,3,False)="yes", Sum(D1:G1), Average(B1:C1)) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation in left corner | Excel Worksheet Functions | |||
| Sumproduct formulas & slow response | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
