M$ Excel

[geoschmo]

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 ]

[Fyron]

Thank you Geo! Is there anything you don't know? (hehe, that rhymes! )

Thanks to everyone else that offered solutions too.

[Fyron]

New question:

I want to have 1 cell that has the damage at range line from components.txt in it. eg:

20 18 16 14 0 0 0 0 0 0 0 0 0 0 0 0 0

I have the damage at each range calculated in a separate cell. How do I get 1 cell to make a list of numbers based off of those cells?

[geoschmo]

=CONCATENATE(A1," ",B1," ",C1," ",D1)

[Fyron]

Ok, thanks!

[Urendi Maleldil]

Is there a way to reverse concatenate something?

[Suicide Junkie]

You mean to take a substring?