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 suss this one out however :-
IF(((None*Ntwo)+(Nthree*Nzero))/(Nthree+None)>100,100,((None*Ntwo)+(Nthree*Nzero))/(Nthree+None))
When I export to excel, this works fine, but in my app, with Nzero=80, None=30, Ntwo=150 and Nthree=40, the answer I'm getting is 110, whereas it should be 100. This is quite critical as the effects of it are hidden and it's only by chance that we came across the incorrect data after doing some re-testing elsewhere.
Help would be much appreciated.
Sandra