Batch solve complex excel formula

Hello,

I am new to this forum and hope to get your help!

I have a complex excel formula with many conditionals, and trying to "apply" the formula to a datasheet of 5,000 rows.

It would actually be difficult to copy the formula 5000 times. I am wondering if it is possible to keep the formula in 1 sheet in excel, and apply it to 5000 rows on another sheet to calculate 5000 results?

I have done a lot of google searching but I don't think I've come up with the right terms to describe what I am looking for, hope to get your help.

Thank you!
Shawn

Formula:

Please Login or Register  to view this content.

Probably need more info before we can be of much help. Maybe post a copy of your workbook so we can see what you're trying to do?

Thank you, I've attached my example excel file.

I am trying to run the data rows (Data Sheet) through the "Three Formulas" sheet and then record the result back on the data sheet in the appropriate boxes.

There are 4 inputs from the data sheet, which feed into the 3 formulas.

Then, the results are in yellow, green, and blue, which I would like to record in the corresponding yellow, green and blue column in the data sheet. I've filled in the 1st row in the Data sheet with the intended result of the completed run.

Hopefully, I've explained myself more clearly, sorry for the confusion.

You can see the formulas are quite complex, so I guess my question can be rephrased as: How can I run data through a preexisting formula in order to record a result in an automated manner?

I would definitely think VBA would be a better option than formulas for this.

Originally Posted by AliGW

Shall I move the thread to the VBA section?

Please I think so, thanks.