How to base a formula off another formula column

HI All I could really use your help - I need to create formulas, that one of the values would be pulled in from another formula column - but it just wont let me.

The first formula column is to calculate a min rate CONCATENATE(“\$”, ROUNDUP({Expected Rate for a 40 hr week} * 12 / 52 / 40, 2))

this works perfectly

then I need to calculate in a separate column a margin based on the first column so have done this
CONCATENATE(“\$”, IF({Expected Rate for a 40 hr week} * 12 / 52 / 40 < 9, 9, ROUNDUP({Expected Rate for a 40 hr week} * 12 / 52 / 40, 2)))

however it seems to break the formula when you base it on the value of another formula

Hello! In my team, we use various formulas for different things.
I’m not sure if I understood correctly what you want to do, but hopefully this helps you.

To use the value from another column in your formula, you just need to mention the column within {}. I’m attaching some photos to see if they’re helpful. I’m sorry if I didn’t understand something

Columns

Formula on “Formula Column”

Formula on “Formula 1” Column

That way you can reference the values of other columns in your second formula.
Hope this helps!

Hi Kitty,

If you want to add a \$ sign to your column, you don’t need to concatenate it. Simply go to the bottom of your column, click on the Summary cell and pick the \$ as unit.

I don’t see where you are referencing your first formula in your syntax. But I tested this and it works.

``````IF({Expected Rate for a 40 hr week} * 12 / 52 / 40 < 9, 9, ROUNDUP({Expected Rate for a 40 hr week} * 12 / 52 / 40, 2))
``````

If you want to reference the first formula (called {Formula 1 } below), then this will work:

``````IF({Formula 1} < 9, 9, ROUNDUP({Expected Rate for a 40 hr week} * 12 / 52 / 40, 2))
``````

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.