October 24th, 2002, 02:21 PM
|
 |
National Security Advisor
|
|
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
|
|
Re: M$ Excel
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 ]
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|