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.
|