Forum Discussion
Madsnielsen97
Feb 17, 2021Copper Contributor
Limiting number of decimals in a VARIABLE SENTENCE
Hello, I am trying to make a variable sentence that will show the calculations used to arrive at a number i.e. a unit cost*number of units, next to the result. I am currently using: =" " & I5...
HansVogelaar
Feb 17, 2021MVP
For example:
=" " & TEXT(I52;"0,00") & " X " & TEXT(H17;"0,00") & " "
(I assumed that you are using comma as decimal separator)