Re: M$ Excel
I've had the same problem several times, and never did get it to work. I had to go around it by using two steps.
Place =PRODUCT(Sheet1!F2*(Sheet1!G2-(Sheet1!J2*(n-1)))*Sheet1!H2) far off to the right like in the BA2.
Then use =IF(Sheet1! K 2 < n,0,BA2 )". equation was creating a HTML tag, had to put some extra spaces in there
There should be a way to use the entire equation in one step, but I haven't been able to get it to work. As a precaution, there are several other of the formula's in excel that cause the same difficulties.
[ October 24, 2002, 12:26: Message edited by: Atraikius ]
|