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.
Dag470
Aug 02, 2022Copper Contributor
Thank you, works perfect 🙂