Quote:
Originally posted by Imperator Fyron:
If I remove the quotes and/or the PRODUCT, it tells me that the formula has errors. The formula works fine when not in an IF statement.
|
Fyron,
The problem is the equal sign before the PRODUCT. Take out the equals sign there and the quote marks, leave the equals sign before the IF, and your single formula should work fine.
code:
=IF(Sheet1!K2<n,0,PRODUCT(Sheet1!F2*(Sheet1!G2-(Sheet1!J2*(n-1)))*Sheet1!H2))
Geoschmo
[ October 24, 2002, 13:23: Message edited by: geoschmo ]