Formula Too Long

**heather1209** · 12-27-2011, 08:18 PM

Hello again

I need help possibly consolidating a formula or finding another way to do a formula since it's too long. Here's what I need it to be which is too long:

Please Login or Register  to view this content.

Basically, what I have is a spreadsheet that has drop downs that a user will choose from and once they choose a drop down, the above formula will put a value in the cell and each drop down adds another value, up to 15 drop down/values.

**Palmetto** · 12-27-2011, 08:25 PM

Maybe others will not go blind reading that "eye chart" (aka "formula).

However, it would be best if you clearly explain your objective and upload a sample workbook (fake data) that shows a few examples of the desired outcome.
Include only enough data to help with the solution.

**heather1209** · 12-27-2011, 08:54 PM

Good point! I just created an example out of my worksheet. I'm attaching it here.

**Marcol** · 12-27-2011, 09:29 PM

@ Palmetto

Don't open the sample attachment, it will ruin your eyes unless you are wearing a welders' visor!
It might even irrepairably destroy your chrystal ball ...

**heather1209** · 12-27-2011, 09:31 PM

I don't understand, what is wrong with the spreadsheet? What can I do to fix it?

**DonkeyOte** · 12-28-2011, 05:35 AM

heather1209,

I think you would be best served breaking the calculations out... e.g.:

Please Login or Register  to view this content.

Obviously Col Q used only for sake of demo. could be wherever (even on a different sheet) and/or column could be hidden.
(Note: Q2 assumed to be empty)

The above is not an exact replica in so far as should have items selected out of sequence (eg 1, 2, 4) the above would list 1,2 & 4 whereas original would list only 1,2 - was not sure which to be accurate.