Page 1 of 1

Error on CalculateSheet

Posted: Mon Dec 04, 2006 2:20 pm
by Sandra
After upgrading to version 3.0 and applying the 3.00.06 update, I am still getting errors where the previous version had none.

Currently, having set up the formula etc, on the first CalculateSheet I get

'Calculate error on cell' which has the following formula

((-A1*A2)+A3+(A4*A5)+(A6*0*(1-A7))+(Erate*(A8+A9)))/A10

where Erate is named cell with another formula. It's quite a complex spreadsheet, but was working ok with version 2.0. If you need an example of the spreadsheet, let me know.

Posted: Tue Dec 05, 2006 9:09 am
by larsa
Hello

The problem was the unary minus in "-A1". An update will be posted within a day.


Lars Arvidsson