Search found 2 matches
- Fri Jan 26, 2007 12:38 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Problems with IF formula
- Replies: 1
- Views: 2465
Problems with IF formula
I'm having problems with some formula which worked well with version 2.0 but are now behaving differently with 3.0. The following formula now doesn't work : 'IF(NStar>=100,((Ntwo-100)/nthree),((Nstar-Nzero)/None))' but when I removed the = it worked ( it kept choosing the true option before ). Can't...
- Mon Dec 04, 2006 2:20 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Error on CalculateSheet
- Replies: 1
- Views: 2333
Error on CalculateSheet
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))+(Era...