Login Page - Create Account

Support Board


Date/Time: Sat, 28 Dec 2024 07:19:19 +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)