Hello, There are times that I use spread sheets for something other than ledgers. A fuel log would be one such application, another would be the value of parallel resistors. (The formula for that is Rt=1÷(1/R1+1/R2+…1/Rn) for what it’s worth.) I like to have columns of repeating formulae like that, but that yields divide by 0 errors. Is it possible to add an option to the effect of “treat divide by blank cells as blank” or something similar? Using the resistor example, if the desired Rt is a standard value like 1,000, then R2 and up would be omitted. But leaving them blank results in an error. Not a huge deal, as that particular line can be altered for the final BOM, but if during testing it is determined to have to be altered, then it may need to be entered again. And it does trigger a minor OCD reaction…
Again, just something for the wish list. Thanks, Chuck DeVivo Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
