View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sfrancoe
 
Posts: n/a
Default 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))