Extending repeated if function for continuous cells

[falieson]

My function is currently, =IF(ISNUMBER(C31),(C31)*C33+IF(ISNUMBER(D31),(D31)*D33+IF(ISNUMBER(E31),(E31)*E33)))

This sucks that I will have to continue this loop all the way down to Q, any better way to do it?

thanks in advance!

[WinteE]

Would you try a User Defined Function ?

[falieson]

Huh? Isn't there anything built into Excel to handle loops or anything similar to this?

[WinteE]

Not for as far as I know, but perhaps there is.

I'd be glad to help you with a UDF if you want to.

Erik

[falieson]

anyone else?

Or how would I make a function to do this?

[WinteE]

See attached file.

The MultiplyColumnIndex points to columns at the right (positive) as well as columns at the left (negative).

Succes,
Erik