Why I love Excel . . .

[Harlan Grove]

.. . . not!

Just fixed 5 formula errors in a workbook I maintain. (Yes, I do make
errors in spreadsheet formulas.) The original and changed formulas were

From
=IF(ISNUMBER(C11),MIN(C11,Limit-C11),"")
=N(Summary!C9)+N(Summary!C9)
=N(Summary!C10)+N(Summary!C10)
=N(Summary!C11)+N(Summary!C11)
=N(Summary!C12)+N(Summary!C12)

To
=IF(ISNUMBER(E12),MIN(E12,Limit-E12),"")
=N(Summary!C9)+N(Summary!E9)
=N(Summary!C10)+N(Summary!E10)
=N(Summary!C11)+N(Summary!E11)
=N(Summary!C12)+N(Summary!E12)

That's it! Old file size 410KB, new file size 383KB. While I shouldn't
complain about a fluke REDUCTION in file size, Excel is just too
bizarre with regard to file size changes.

 

[Nick Hodge]

Harlan

it's the 'E' numbers...kids'll tell you hyperactivity slims you down ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)