View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Nested If(and(...

Hmmm... I made the substitutions you recommended and saw no decrease in
file size (plus or minus 128 bytes) nor change in calculation time (plus
or minus a millisecond), with a significant reduction in readability.


In article ,
"Bill Ridgeway" wrote:

BTW it would be better if you reduced BAD and FINE to, say 0 (zero) and 1
(one). This could substantially reduce the size of a spreadsheet and
re-calculation.