Login Page - Create Account

Support Board


Date/Time: Thu, 03 Jul 2025 19:12:22 +0000



Post From: cpu usage

[2015-12-16 04:41:46]
User53474 - Posts: 19
The problem with the converted spreadsheet I sent you isn't that just some of the formulas didn't copy over, it's that on several of the sheets NONE of the formulas copied over. Seems like a problem that should be addressed imo.

Regarding problems with specific formulas, here is one I tried reentering from old to new and it gives me a syntax error on the new spreadsheet:

=IF($BV$4<>0,INDEX($BV$5:$BV$100,SUMPRODUCT(MATCH(1,--($BV$5:$BV$100<>$BV$4),0))),$CM$30)