Forum Discussion
Dag470
Jul 26, 2022Copper Contributor
Sentence from excel data
How i can make sentence in 9B update automatically as when cost changes in C column(Column D is formula too)? Please can someone share formula for it 🙂
- Jul 26, 2022
Dag470 I made a start in the attached example and suggest that you finish it yourself. Note that I used a helper column that generates the (£0.5k) type notation. You can do that in B9 as well but then the formula becomes much longer and more difficult to maintain.
Riny_van_Eekelen
Jul 26, 2022Platinum Contributor
Dag470 I made a start in the attached example and suggest that you finish it yourself. Note that I used a helper column that generates the (£0.5k) type notation. You can do that in B9 as well but then the formula becomes much longer and more difficult to maintain.
- Dag470Aug 02, 2022Copper ContributorThank you, works perfect 🙂