cancel
Showing results for 
Search instead for 
Did you mean: 

Combining Multiple Formulas

ryanshores70
Discoverer
0 Kudos

Hey there.

I have a collection of rudimentry formulas which I have generated, and want to have these all combined into 1 overarching formula.

What would be the best route to do so?

each formula looks for a specific piece of data and then populates accordingly. So nothing to out there.

All suggestions are welcomed.

Thanks

Ryan

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

Keep the separate formulas you have created. To combine them, create a formula that calls each of them to get you the data you're looking for. Note that to combine the data as text, you'll need to convert any numeric or date data to string using ToText(). If you're final result needs to be a number, you'll have to convert any strings to numbers.

-Dell

ryanshores70
Discoverer
0 Kudos

Hi there Dell, thanks for the comment. I have tried this. And the results dont appear to pull through.

By adding each Formula to a main Formula, they dont pull through.
Each Formula pulls through on its own when added to the spread sheet, but when combined it doesnt appear to work

Below is a screenshot of how I have set this up

Thanks
Ryan

DellSC
Active Contributor
0 Kudos

What do the inner formulas look like? Could any of them return Null? Are they returning strings or numbers?

-Dell